SQL Statements › WHENEVER › Example

Example

The following identifies the exception conditions and the next statement to be executed in the order listed:

1. If an error is produced, go to HANDLERR.
2. If a warning code is produced, continue with the normal flow of the program.
3. If no results are found, go to ENDDATA.