15.00 - Impact of Session Mode on DDL Requests in Procedures - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Impact of Session Mode on DDL Requests in Procedures

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.