16.20 - SPL1142: "%s:E(L%d), Dynamic SQL statement must be the only statement in a multi-statement request." - 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

SPL1142: "%s:E(L%d), Dynamic SQL statement must be the only statement in a multi-statement request."

Explanation:

If Dynamic SQL statement is specified in multi-statement request within stored procedure, it should be the only statement.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Dynamic SQL statement cannot be submitted in a list in multi-statement request. Please correct and resubmit.