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.