Character Set Hierarchy|Extended Character Sets - Character Set Hierarchy - Parallel Transporter

Teradata® Parallel Transporter Reference - 20.00
Deployment
VantageCloud
VantageCore
Edition
IntelliFlex
Lake
Enterprise
VMware
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-12-06
dita:mapPath
mjn1691132485167.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
lifecycle
latest
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 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 mentioned 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.