17.00 - Example: HELP PROCEDURE with Unicode Pass Through Set - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Stored procedures inherit the Unicode Pass Through attribute of the session in which they are created:
Setting Unicode Pass Through
S On for the session
F Off for the session.

The following output shows that Unicode Pass Through was set to on for the session that created the procedure.

HELP PROCEDURE sp1 ATTRIBUTES;

*** Help information returned. One row.

     Transaction Semantics  TERADATA
                Print Mode  N
                  Platform  LINUX
             Character Set  ASCII
Default Character DataType  LATIN
                 Collation  ASCII
                  SPL Text  Y
            Version Number  11
          Default Database  USER2
            Warning Option  Y
         Creation Timezone  00:00
  Creation Timezone String
      Unicode Pass Through  S