15.00 - Significance of Platform and Session Mode For REPLACE PROCEDURE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Significance of Platform and Session Mode For REPLACE PROCEDURE

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.