16.10 - Specifying an Extended Character Set in a Teradata PT Job Script - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

Session Character Set: the session character set in a Teradata PT script is determined in one of the following ways:

  • Default: It is not necessary to specify any session character set before defining the job if you are using the default session character set. The default session character set for all Teradata PT jobs are:
    • ASCII for network-attached client systems
    • EBCDIC for mainframe-attached client systems
  • Specified: To use a session character set other than ASCII or EBCDIC, specify the session character set by including a session character set identification clause:
    USING CHARACTER SET <characterSet>

    The identification clause is specified right before the DEFINE JOB <jobname> statement.

    For example:

    DEFINE JOB LOAD_TABLES
    (
           …
           …
           …
    );

    In the above example, the session character set will be set to the default session character set: ASCII (network) and EBCDIC (mainframe).

    In the following example, the session character set, an extended session character set, will be set to KANJISJIS_0S:

    USING CHARACTER SET KANJISJIS_0S
    DEFINE JOB LOAD_TABLES
    (
           …
           …
           …
    );

Extended Identifiers: an identifier inside a Teradata PT script is non-keyword name that is used to uniquely identify an object. For example:

  • DEFINE JOB JOB_NAME

    where JOB_NAME is the identifier.

  • DEFINE OPERATOR FILE_READER

    where FILE_READER is the identifier.

  • STEP Setup_Tables

    where Setup_Tables is the identifier.

Teradata PT allows identifiers inside a job script to contain extended characters, provided they match the extended session character set. However, when using extended identifiers in Teradata PT, delimit the extended identifier with double quotes. For example:

DEFINE JOB "JOB_NAME_WITH_KANJISJIS_0S_CHARACTERS"
DEFINE OPERATOR "FILE_READER_WITH_UTF8_CHARACTERS"
STEP "Setup_Tables_with_TCHBIG5_1R0_characters"