| Advanced features / Exceptions | |
Exception classes indirectly define the exception type.
The default action can be changed by specifying the exception class in the WHENEVER instruction.
| Class | Error reason | Default Action |
|---|---|---|
| ERROR (or SQLERROR) | Language or SQL statement error. | STOP |
| ANY ERROR (or ANY SQLERROR) | Language, SQL statement and expression error. | CONTINUE (1) |
| NOT FOUND | SQL statements returning status NOTFOUND. | CONTINUE |
| WARNING | SQL statements setting SQLCA.SQLAWARN flags. | CONTINUE |
WHENEVER ANY ERROR CONTINUE