Specifying an Extended Character Set in a Teradata PT Job Script
Session Character Set: the session character set in a Teradata PT script is determined in one of the following ways:
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:
where JOB_NAME is the identifier.
where FILE_READER is the identifier.
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"