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 one of the following values:

If SQLCODE contains any other value, procedure SQLStatusCheck is executed. Values less than -14024 indicate errors serious enough to warrant terminating the program.