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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

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.