Error Handling in isql
From InterBase
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.