16.20 - SPL1067: "%s:E(L%d), Transaction control statement COMMIT is not allowed in Teradata mode." - 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

SPL1067: "%s:E(L%d), Transaction control statement COMMIT is not allowed in Teradata mode."

Explanation:

If a stored procedure is being created in Teradata (BTET) mode, the ANSI mode-specific transaction control statement COMMIT cannot be specified in the SPL source text.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Remove the ANSI mode specific transaction control statement or change the session mode to ANSI before creating the procedure.