Usage Notes - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
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 network-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 network-attached systems.
  3. Teradata Database default, determined by a query from Teradata FastLoad.