>>-WHENEVER--+-SQLERROR----------+------------------------------>
             +-NOT FOUND---------+
             |  (1)              |
             +--------SQLWARNING-+
             |  (1)              |
             '--------ERROR------'
 
>--+-CONTINUE--------------------+-----------------------------><
   +-+-GOTO--+--+-:label-------+-+
   | '-GO TO-'  |  (1)         | |
   |            '--------label-' |
   +-CALL--routine---------------+
   '-STOP------------------------'
 

1. Informix extension

The WHENEVER statement is equivalent to placing an exception-checking routine after every SQL statement. The following table summarizes the types of exceptions for which you can check with the WHENEVER statement.

Programs that do not use the WHENEVER statement do not automatically abort when an exception occurs. Such programs must explicitly check for exceptions and take whatever corrective action their logic specifies. If you do not check for exceptions, the program simply continues running. If errors occur, however, the program might not perform its intended purpose.

The first keyword that follows WHENEVER specifies some type of exceptional condition; the last part of the statement specifies some action to take when the exception is encountered (or no action, if CONTINUE is specified). The following table summarizes possible actions that WHENEVER can specify.