Previous Topic: WHENEVERNext Topic: Processing


Description

Use the following clauses to identify the type of exception condition.

NOT FOUND

Identifies any condition that results in an SQL return code of +100.

SQLERROR

Identifies any condition that results in a negative SQL return code.

SQLWARNING

This CA Datacom/DB extension allows you to identify any condition that results in a warning condition (SQLCA-WARNING is W) or that results in a positive SQL return code other than +100.

Use the following clauses to specify the statement to be executed when the identified type of exception condition exists.

CONTINUE

Causes the program to continue execution with the next sequential statement of the source program.

GO TO or GOTO

Causes transfer of control to the statement identified by host-label.

host-label

You can specify a single token, optionally preceded by a colon. The form of the token depends on the host language. For example, in COBOL it can be a section-name or an unqualified paragraph-name.