WHENEVER
Syntax
WHENEVER SQLERROR|OSERROR EXIT [<exit_code>]|CONTINUE|ABORT [ROLLBACK|COMMIT];
Description
This statement defines the behavior of EXAplus in the event of errors. WHENEVER SQLERROR responds to errors in the execution of SQL statements, WHENEVER OSERROR to operating system errors (file not found, etc.).
The behavior can be specified as follows:
Command | Description |
---|---|
EXIT | Quits EXAplus. |
CONTINUE | Continues program operation despite the occurrence of an error. |
ABORT | Aborts the execution of statements, but doesn't close EXAplus. |
CONTINUE is the default setting for both types of error (and EXIT if EXAplus is started with the parameter -x).