HP 3000 Manuals HP 3000 Manuals
Explicit Status Checking In explicit status checking, shown at 9 in Figure 3-1 , you explicitly examine an SQLCA field for a particular value, then perform an operation if the value exists. In this example, the SQLCA field named SQLCODE is examined to determine whether it contains a value less than -14024. SQLCODE values with greater negative values than -14024 indicate errors serious enough to warrant terminating the program. If SQLCODE is less than -14024 in this case, the ABORT-FLAG is set and the program is terminated after paragraph S200-SQL-EXPLAIN is executed.