SQL$HELP72.HLB  —  WHENEVER  Arguments

1  –  CONTINUE

    Specifies that the program continue execution with the next
    sequential statement following the statement that generated an
    error.

2  –  GOTO

    Syntax options:

    host-label-name | host-label-number

    Specifies that the program branch to the statement identified
    by the host label. The form of the host label depends on the
    host language. You can use a colon (:)  before a host label
    represented by a name, but not before a host label represented
    by a number.

3  –  NOT_FOUND

    Indicates the exception condition returned when SQL processes all
    the rows of a result table:

    o  When a cursor referred to in a FETCH, UPDATE, or DELETE
       statement is positioned after the last row

    o  When a query specifies an empty result table

    This is the same condition identified by a value of 100 in the
    SQLCODE variable, the value of '02000' in the SQLSTATE variable,
    and by the RDB$_STREAM_EOF error.

4  –  SQLERROR

    Indicates any error condition. For the SQLERROR argument of
    the WHENEVER statement, SQL defines an error condition as any
    condition that returns a negative value to SQLCODE.

5  –  SQLWARNING

    Indicates any warning condition.
Close Help