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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ruk1608578422758.ditamap
dita:ditavalPath
vax1619194969834.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.