16.20 - Example: HELP PROCEDURE with Unicode Pass Through Set - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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