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.
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 table names, work table names, and error table names can have multibyte characters. |
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:
|
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:
|
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.
|