Exception classes

The exception classes indirectly define the exception type. The default action can be changed by specifying the exception class in the WHENEVER instruction.

Table 1. Exception classes
Class Error reason Default Action
ERROR (or SQLERROR) Language or SQL statement error. STOP
ANY ERROR (or ANY SQLERROR) Language or SQL statement and expression error. CONTINUE (1)
NOT FOUND SQL statements returning status NOTFOUND. CONTINUE
WARNING SQL statements setting SQLCA.SQLAWARN flags. CONTINUE