16.20 - Significance of Platform and Session Mode For REPLACE PROCEDURE - 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)

If a procedure created in Teradata session mode is being replaced in ANSI session mode, it acquires the new session mode attributes and thereafter can only be performed in ANSI session mode.

Similarly, if a procedure created in ANSI session mode is replaced in Teradata session mode, it acquires the new session mode attributes and thereafter can only be performed in Teradata session mode.

You can replace an SQL procedure created with one default character set with a different default character set.