16.20 - SPL1035: "%s:E(L%d), Referencing an undefined label or illegal usage of label. - Teradata Vantage NewSQL Engine

Teradata® Vantage - Database Stored Procedure Compilation (SPL Prefix) Messages

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

SPL1035: "%s:E(L%d), Referencing an undefined label or illegal usage of label.

Explanation:

The reason for the error can be one of the following:a. The SPL LEAVE or ITERATE statement in the indicated line is referencing an undefined label, or b. The referenced label is not within an iteration statement that defines the label. The SPL ITERATE or LEAVE statement must reference a label that is associated with an iteration statement. The SPL LEAVE statement (not within a condition handler) can also reference a label associated with the BEGIN-END block of the procedure body.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Verify and ensure that either the label referenced by a LEAVE statement is associated with an iteration statement, or with the BEGIN-END block of the procedure body, or the label referenced by an SPL ITERATE statement is associated with an iteration statement.