SET SESSION CHARSET | Usage Notes | Teradata FastLoad - 17.20 - Usage Notes - FastLoad

Teradata® FastLoad Reference - 17.20

Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-11
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval

The following table describes the things to consider when using the SET SESSION CHARSET command.

Usage Notes for SET SESSION CHARSET 
Topic Usage Notes
Command Placement The SET SESSION CHARSET command must appear before the LOGON command in the Teradata FastLoad job script.
Double Quote Characters in Character Set Name Specifications The names of the character sets must be enclosed in double quote characters.
Priority of Character Set Specifications The order in which the character set is determined for a Teradata FastLoad job is:
  1. User specified by a:
    • Runtime parameter (This specification has the highest priority on all supported platforms.)
    • SET SESSION CHARSET command on workation-attached systems
    • CHARSET parameter in the Teradata FastLoad configuration file
  2. System Parameter Block (SPB) specified by the:
    • HSHSPB on mainframe-attached systems
    • clispb.dat file on workstation-attached systems.
  3. Database default, determined by a query from Teradata FastLoad.