HP 3000 Manuals

ALLBASE/SQL Pascal Application Programming Guide

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:

   *   0, indicating no error occurred.

   *   100, indicating no rows qualified for the SELECT operation.

   *   -10002, indicating more than one row qualified for the SELECT
       operation.

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

MPE/iX 5.0 Documentation