|
|
|
|
|
|
WHENEVER
Defines action to be taken for errors and exception conditions.
Usage
Description
The action taken in the event of a condition arising during execution of an SQL statement is governed by the most recently issued WHENEVER statement. There are three different types of conditions: NOT FOUND, SQLERROR and SQLWARNING. See Return Status and Conditions for a description of the different condition types.
The action taken is as follows:
- CONTINUE
Program execution continues at the next sequential statement of the source program.
- GOTO
Program execution continues at the source code statement identified by host-label, where host-label is a program label in a program written according to the host language.
Restrictions
Notes
If a condition in an SQL statement is not covered by an explicit WHENEVER statement issued earlier in the host program code, CONTINUE will be assumed.
See the Mimer SQL Programmer's Manual for a discussion of the use of WHENEVER in control of different conditions.
Standard Compliance
Standard
Compliance
Comments
SQL92
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|
