Considerations for Multibyte Character Sets - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

Vantage supports multibyte characters in object names when the client session character set is UTF-8 or UTF-16. See International Character Set Support, B035-1125 for a list of valid characters used in object names. If multi-byte characters are used in object names in Teradata MultiLoad script, they must be enclosed in double quotes

The following table shows how multibyte character sets impact the operation of certain Teradata MultiLoad commands, as well as object names in Teradata SQL statements.

Commands Impacting Multibyte Character Sets 
Teradata MultiLoad Command Affected Elements Impact
ACCEPT Utility variables The utility variables can have multibyte characters. If the client does not allow multibyte character set names, then the file name must be in uppercase English.
BEGIN MLOAD Table names:
  • Target tables
  • Work tables
  • Error tables
Target table names, work table names, and error table names can have multibyte characters.

See BEGIN MLOAD and BEGIN DELETE MLOAD.

DML LABEL DML label name The label name in a DML LABEL command can have multibyte characters. The label name may be referenced in the APPLY clause of an IMPORT command.
FIELD Field name The field name specified can have multibyte characters.

The name can be referenced in other FIELD commands, in NULLIF and field concatenation expressions, and in APPLY WHERE conditions in IMPORT commands.

The FIELD command can also contain a NULLIF expression, which may use multibyte characters.

FILLER Filler name The name specified in a FILLER command can have multibyte characters.
IF IF condition The condition in an IF statement can compare multibyte character strings.

See IF, ELSE, and ENDIF.

LAYOUT Layout name The layout name can:
  • Have multibyte characters
  • Be used in the LAYOUT clause of an IMPORT command
CONTINUEIF condition The CONTINUEIF condition can specify multibyte character set character comparisons.
LOGON User name and password The user name and password can have multibyte characters.
LOGTABLE Table and database names The restart log table name and database name can have multibyte characters.
SET Utility variable The utility variable can:
  • Have multibyte characters
  • Be substituted wherever substitution is allowed
TABLE Table and database names The table name (tableref, and the database name if the table name is fully qualified) specified in a TABLE command can have multibyte characters.
Do not use the TABLE command while using UTF-8 and UTF-16 character sets.