Session Mode Impact on DDL Requests in Procedures | Teradata Vantage - 17.10 - Session Mode Impact on DDL Requests in Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)
The behavior of DDL requests specified within the body of SQL procedures at runtime depends on the session mode in place when the procedure is created.
  • A DDL request specified within an explicit transaction in a procedure in Teradata session mode must be the last request specified in that transaction. Otherwise, the system raises a runtime exception.
  • When you perform a procedure in ANSI session mode, each DDL request specified in the procedure body must be explicitly terminated by a COMMIT WORK request. Otherwise, the system raises a runtime exception.