Character Set Specification - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

Vantage for a UNIX system and Vantage for Windows allow establish a character set when invoking Teradata MultiLoad.

Character Sets Supported by Teradata MultiLoad

The following table lists the character sets supported by Teradata MultiLoad. Character sets containing “EBCDIC” as part of the name are for mainframe-attached clients; all others are for workstation-attached clients.

Character Sets Supported by Teradata MultiLoad 
Character Set Name Description Configuration
ASCII Latin Workstation-attached
EBCDIC Latin Mainframe-attached
HANGULEBCDIC933_1II Korean Mainframe-attached
HANGULKSC5601_2R4 Korean Workstation-attached
SCHEBCDIC935_2IJ Simplified Chinese Mainframe-attached
SCHGB2312_1T0 Simplified Chinese Workstation-attached
TCHBIG5_1R0 Traditional Chinese Workstation-attached
TCHEBCDIC937_31B Traditional Chinese Mainframe-attached
KATAKANAEBCDIC Japanese Mainframe-attached
KANJIEBCDIC5026_01 Japanese Mainframe-attached
KANJIEBCDIC5035_01 Japanese Mainframe-attached
KANJIEUC_0U Japanese Workstation-attached
KANJISJIS_0S Japanese Workstation-attached
UTF-8 or UTF8 Unicode Mainframe-attached

Workstation-attached

UTF-16 or UTF16 Unicode Workstation-attached

Methods for Specifying Character Sets

The following table describes five ways to specify the character set or accept a default specification.

Methods for Specifying Character Sets 
Method Description
Configuration File Specification One of the best ways to specify the character set is with the character set specification in the Teradata MultiLoad configuration file, as described earlier:

CHARSET=character-set-name

This allows a standard default character set for several or all Teradata MultiLoad runs, without having to specify the character set explicitly for each run.

Runtime Parameter Specification Another good way to specify the character set is with the character set run-time parameter when Teradata MultiLoad is invoked, as described in Runtime Parameters:
  • CHARSET=character-set-name for mainframe-attached z/OS client systems
  • -c character-set-name for workstation-attached UNIX and Windows client systems
Client System Specification Another way is to specify the character set for the client system before invoking Teradata MultiLoad by configuring the:
  • HSHSPB parameter for mainframe-attached z/OS client systems
  • clispb.dat file for workstation-attached UNIX and Windows client systems
The character-set-name specification used to invoke Teradata MultiLoad always takes precedence over the current client system specification.
Database Default If a character-set-name specification is not used when Teradata MultiLoad is invoked, and there is no character set specification for the client system, the utility uses the default specification in the database system table DBC.Hosts.

If relying on the DBC.Hosts table specification for the default character set, ensure that the initial logon is in the default character set:

  • EBCDIC for mainframe-attached z/OS client systems
  • ASCII for workstation-attached UNIX and Windows client systems
Teradata MultiLoad Utility Default If there is no character set specification in DBC.Hosts, then Teradata MultiLoad defaults to:
  • EBCDIC for mainframe-attached z/OS client systems
  • ASCII for workstation-attached UNIX and Windows client systems

When an AXSMOD is used, Teradata MultiLoad will pass the session character set as an attribute to the AXSMOD for its possible use (most AXSMODs will not make any use of this information). The attribute name will be CHARSET_NAME and the attribute value will be a variable length character string consisting of the character set name.

Rules for Using Chinese and Korean Character Sets

Follow these rules when using Chinese and Korean character sets on mainframe-attached and workstation-attached platforms.

  • Object Names – Object names are limited to A-Z, a-z, 0-9, and special characters such as $ and _.
  • Maximum String Length – The database requires two bytes to process each of the Chinese or Korean characters. This limits both request size and record size. For example, if a record consists of one string, the length of that string is limited to a maximum of 32,000 characters or 64,000 bytes.

For more information about Chinese or Korean character set restrictions, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.

For more information about alternate character sets, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .