16.20 - SPL5013: "%s:W(L%d), Identifier (%s) reference is ambiguous and will be treated as local variable during execution." - 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

SPL5013: "%s:W(L%d), Identifier (%s) reference is ambiguous and will be treated as local variable during execution."

Explanation:

Identifiers used in the statement are ambiguous because the underlying objects referred in the statement do not exist and matching parameter or local variable exist within in the same scope. Hence the identifiers which could have resolved to column references if the object exists, are treated as parameter or local variables.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Change the statement to use non-ambiguous column names and parameter or local variable names and recreate the procedure.