For certain character sets (including multibyte characters), Teradata ARC accepts non-Latin characters as part of an object name. An object name can be a database name, table name, user name, password, or checkpoint name in a Teradata ARC statement. Object names must be no longer than 30 characters.
Teradata ARC also supports input and display of object names in hexadecimal notation. Teradata Database can store and display objects in hexadecimal format to allow object names to be archived and restored from one platform to another. To learn more about using non-Latin characters in object names, refer to SQL Fundamentals (B035-1141).
For example, to archive a database created on a UNIX platform from an IBM mainframe, do not specify the UNIX EUC character set on the IBM mainframe. Instead, specify the database name in the internal hexadecimal format understood by the Teradata Database.
The Teradata ARC allows specifying object names in any of these formats:
- Without quotes. For example, for database DBC:
DBC
- With quotes. For example, for database DBC:
“DBC”
- External hexadecimal:
X’<object name in external hexadecimal format>’
This indicates that the specified hexadecimal string represents a name in the client (external) format. For example, for database DBC:
X’C4C2C3’
- Internal hexadecimal
’<object name in internal hexadecimal format>’XN
This indicates that the specified hexadecimal string represents a name in the Teradata Database internal format. For example, for database DBC:
’444243’XN
A Teradata ARC statement can contain any combination of object name notations. For example, the hexadecimal notation is a valid object name:
’4142’XN.TABLEONE