Character Set Hierarchy
Teradata PT follows strict hierarchies for determining what character set is used:
Communication Sessions
For communication sessions between Teradata PT and the Teradata Database, the following
rules apply in the following order:
User-Determined: The character set specified in the USING CHARACTER SET clause placed immediately
before the DEFINE JOB statement is used above all other character set definitions.
System Parameter Block (SPB): If no user-specified character set is specified, the character set is defined in
the HSHSPB file on mainframe-attached systems or in the clispb.dat file on network-attached
systems.
Teradata Database: If neither of the above is specified, Teradata PT uses the character
set defined in the Teradata Database. This rule applies to the following operators
that communicate with the Teradata Database:
Load
Update
Export
Stream
SQL Inserter
SQL Selector
DDL
Data Transmission: If the character set is not specified in a job that uses the DataConnector operator,
Teradata PT uses the platform default character set of ASCII or EBCDIC to export data
to the Teradata Database.