Usage Notes - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.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 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.