16.20 - Impact of Session Mode on DDL Requests in Procedures - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
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.