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 | Message | Meaning |
---|---|---|
< 0 |
|
Error occurred; statement did not execute |
0 |
|
Successful execution |
+1–99 |
|
System warning or informational message |
+100 |
|
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.