Error Handling and Recovery (Application Requirements)
Go Up to Application Requirements
Every time a SQL statement is executed, it returns an error code in the SQLCODE
variable. SQLCODE
is declared automatically for SQL programs during preprocessing with gpre
. To catch run-time errors and recover from them when possible, SQLCODE
should be examined after each SQL operation.
SQL provides the WHENEVER
statement to monitor SQLCODE
and direct program flow to recovery procedures. Alternatively, SQLCODE
can be tested directly after each SQL statement executes. For a complete discussion of SQL error handling and recovery, see Error Handling and Recovery.