16.20 - SPL1104: "%s:E(L%d), Unexpected text on LHS of SET statement." - 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

SPL1104: "%s:E(L%d), Unexpected text on LHS of SET statement."

Explanation:

The target of the SET statement, i.e., the LHS of the SET statement in the indicated line must contain only local variables, and/or INOUT/OUT parameters.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

The LHS of a SET statement cannot be a Reserved Word or a System variable. So check whether the LHS for these and change if they are one. The LHS can be a valid identifier. The LHS cannot be any undefined variable.