16.10 - Character Set Hierarchy - Parallel Transporter

Teradata Parallel Transporter Reference

Parallel Transporter
Release Number
July 2017
Content Type
Programming Reference
Publication ID
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.