Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


WHENEVER


Defines action to be taken for errors and exception conditions.



Usage

Embedded.

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, SQLEXCEPTION and SQLWARNING. See Return Status and Conditions for a description of the different condition types.

The action taken is as follows:

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.

Example

      ...
       GOTO 1025
       EXEC SQL WHENEVER SQLEXCEPTION GOTO 1600
 1025  CONTINUE
       EXEC SQL DELETE FROM MYTABLE
      ...

Standard Compliance

Standard
Compliance
Comments
SQL-2016
Core
Fully compliant.


Mimer
Mimer Information Technology AB
Phone: +46 18 780 92 00
info@mimer.com
Mimer SQL Documentation TOC PREV NEXT INDEX