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

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.