Error Handling in isql

Go Up to Command-line isql Tool

InterBase handles errors in isql and DSQL in the same way. To indicate the causes of an error, isql uses the SQLCODE variable and the InterBase status array.

The following table lists values that are returned to SQLCODE:

SQLCODE and Message Summary

SQLCODE	Message	Meaning
< 0	SQLERROR	Error occurred; statement did not execute
0	SUCCESS	Successful execution
+1–99	SQLWARNING	System warning or informational message
+100	NOT FOUND	No qualifying rows found, or end of current active set of rows reached

For a detailed discussion of error handling, see the Embedded SQL Guide. For a complete listing of SQLCODE and InterBase status array codes, see the Language Reference Guide.