SET SESSION CHARSET

SET SESSION CHARSET - FastLoad

Teradata FastLoad Reference

Product

FastLoad

Release Number

15.10

Language

English (United States)

Last Update

2018-10-07

dita:id

B035-2411

lifecycle

Product Category

Teradata Tools and Utilities

Purpose

The SET SESSION CHARSET command specifies which character set is in effect during a specific Teradata FastLoad invocation.

Note: The SET SESSION CHARSET command applies only to network‑attached systems. For mainframe‑attached systems, see “Invoking Teradata FastLoad” on page 33 for a description of the CHARSET parameter.

Syntax

where

Syntax Element	Description
ASCII	ASCII character set.
KANJIEUC_0U	Kanji Extended UNIX Code character set.
KANJISJIS_0S	Combined JIS‑x0208 and JIS‑x0201 character set developed by Microsoft.

Usage Notes

Table 50 describes the things to consider when using the SET SESSION CHARSET command.

Table 50: 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.