Character Set Hierarchy - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata PT follows strict hierarchies for determining which character set is used.

Communication Sessions
  • For communication sessions between Teradata PT and the 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 workstation-attached systems.
    • Database: If neither of the above is specified, Teradata PT uses the character set defined in the database. This rule applies to the following operators that communicate with the 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 database.