WHENEVER (E-SQL)

The WHENEVER statement specifies the action (CONTINUE, GOTO, or CALL) to be taken when one of three possible SQLCODE conditions is met following the execution of an Embedded SQL statement.

Syntax

WHENEVER {SQLWARNING | SQLERROR | NOT FOUND} {CONTINUE | GOTO stmt_label | CALL function()}

Arguments

SQLWARNING

Specifies that an Embedded SQL warning occurred and was stored in the SQLCA data structure.

SQLERROR

Specifies that a Microsoft® SQL Server™ message was received and stored in the SQLCA data structure.

NOT FOUND

Specifies that no rows were returned from a valid and properly executed SELECT statement or that a FETCH statement returned no more rows, and that SQLCODE was set to 100 in the SQLCA data structure.

CONTINUE (default)

Specifies running the next physically sequential statement in the source program.

stmt_label

Is the place in the program where control is assumed.

function()

Is a function in your application. Parentheses () are required following the function name (function()). If parentheses are omitted, the function is not called. The function can include parameters.

Remarks

SQLCODE conditions have the following values.

For more information about how to handle specific error conditions programmatically using SQLSTATE values, see SQLSTATE Messages.

The following SQLCODE values are revised in ESQL/C version 6.5 and are carried to version 7.0.

WHENEVER statement actions are related to the position of statements in the source code, not in the run sequence. The default is CONTINUE for all conditions.

Examples

EXEC SQL WHENEVER sqlerror GOTO displayca;

    .

    .

    .

EXEC SQL WHENEVER sqlerror CALL error_funct(param);

See Also