16.20 - SPL1110: "%s:E(L%d), Invalid SQL DELETE 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

SPL1110: "%s:E(L%d), Invalid SQL DELETE statement."

Explanation:

The SQL DELETE statement in the indicated line is not an SQL DML statement; rather it is an SQL DDL statement, viz., DELETE DATABASE, which is not allowed in the SPL source text.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Correct/remove the SQL UPDATE/DELETE statement in the indicated line.