16.20 - SPL1038: "%s:E(L%d), SQL SELECT returns %d columns, but INTO clause has %d target variables." - 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

SPL1038: "%s:E(L%d), SQL SELECT returns %d columns, but INTO clause has %d target variables."

Explanation:

There is a mismatch in the number of fields projected in the SELECT clause of the SQL SELECT statement and the number of local variables and/or INOUT/OUT parameters specified in the INTO clause.Generated By: TSP module.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Verify and add or delete the number of fields in the SELECT clause to match the number of target variables in the INTO clause or vice versa.