Defines action to be taken for errors and exception conditions.
The action taken in the event of a condition arising during execution of an SQL statement is governed by the most recently issued
WHENEVERstatement. There are three different types of conditions:
SQLWARNING. See Return Status and Conditions for a description of the different condition types.
The action taken is as follows:
If a condition in an SQL statement is not covered by an explicit
WHENEVERstatement issued earlier in the host program code,
CONTINUEwill be assumed.
Example... GOTO 1025 EXEC SQL WHENEVER SQLEXCEPTION GOTO 1600 1025 CONTINUE EXEC SQL DELETE FROM MYTABLE ...
Mimer Information Technology AB
Phone: +46 18 780 92 00