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 workstation-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 this 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 ( … … … );
- 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"