DSNH4779I csectname LINE nnnn COL cc LABEL label SPECIFIED statement IS NOT VALID

Explanation

In an SQL procedure, label is specified on a GOTO or LEAVE statement. label is not defined or is not a valid label for the statement.

The label on a LEAVE statement must be the label for a LOOP, REPEAT, WHILE, or compound statement.

The label in a GOTO statement must be defined within a scope that the GOTO statement can reach.
  • If the GOTO statement is defined in a compound statement, label must be defined inside the same compound statement.
  • If the GOTO statement is defined in a handler, label must be defined in the same handler and must follow the other scope rules.
  • If the GOTO statement is defined outside a handler, label must not be defined within a handler.

System action

The statement cannot be processed.

User response

Change the label in the LEAVE statement to match the label on the LOOP, REPEAT, WHILE, or COMPOUND statement that contains the LEAVE statement.

Ensure that the label in the GOTO statement is defined within a scope that the GOTO statement can reach.

Severity

8 (error)