16.10 - Character Set Hierarchy - 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)

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.