Description
The NOT FOUND, SQLERROR, or SQLWARNING clause is used to identify the type
of exception condition.
- NOT FOUND
- Identifies any condition that results in an SQLSTATE of '02000'
or an SQLCODE of +100.
- SQLERROR
- Identifies any condition that results in an SQLSTATE value where the
first two characters are not '00', '01', or '02'.
- SQLWARNING
- Identifies any condition that results in an SQLSTATE value where the
first two characters are '01', or a warning condition (SQLWARN0 is 'W').
The CONTINUE or GO TO clause are used to specify the next statement to
be executed when the identified type of exception condition exists.
- CONTINUE
- Specifies the next sequential instruction of the source program.
- GOTO or GO TO host-label
- Specifies the statement identified by host-label. For host-label,
substitute a single token, optionally preceded by a colon. The form of the
token depends on the host language. In a COBOL program, for example, it can
be a section-name or an unqualified paragraph-name.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.