After an application program executes a SQL statement, it can examine a return code (or status code). This return code indicates whether the statement executed successfully or failed and gives the reason for the failure. You can use the same mechanism to indicate the success or failure of a CALL statement to a procedure.
Error reporting uses either the SQLCODE or SQLSTATE status descriptions. Whenever a SQL statement is executed, a value is placed in special procedure variables called SQLSTATE and SQLCODE. That value indicates whether or not there were any unusual conditions encountered while the statement was being performed. You can check the value of SQLSTATE or SQLCODE in an IF statement following a SQL statement, and take actions depending on whether the statement succeeded or failed.
For example, the SQLSTATE variable can be used to indicate if a row is successfully fetched. The TopCustomerValue procedure presented in “Using cursors on SELECT statements in procedures” used the SQLSTATE test to detect that all rows of a SELECT statement had been processed.
For full descriptions of SQLCODE and SQLSTATE error and warning values and their meanings, see Sybase IQ Error Messages.
