15.00 - Example Object Name in HELP Output - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Example Object Name in HELP Output

Assume the existence of a Japanese language table named

If you submit a HELP DATABASE statement for the database that contains the table, the HELP output includes object names/titles, followed by the 3 associated name/title fields, the content of which differs based on the session character set.

For a UTF8 or UTF16 session, where the table name translates into the session character set, the table portion of the HELP output appears similar to the following, with some output lines omitted for clarity:

Table Name:

Table Dictionary Name:

Table SQL Name:

Table UEscape:?

Title: BigTable1

Dictionary Title: BigTable1

SQL Title: 'BigTable1'

Title UEscape: ?

where the ? value for UEscape represents NULL, which is used because all SQL Name and SQL Title characters are translatable into the session character set and no delimiter is required.

For an ASCII session, where the table name does not translate into the session character set, the table portion of the HELP output appears similar to the following:

Table Name: ^Z^Z^Z^Z

Table Dictionary Name: ^Z^Z^Z^Z

Table SQL Name: U&"\FF83\FF70\FF8C\FF9E\FF99"

Table UEscape: \

Table Title: BigTable1

Dictionary Title: BigTable1

SQL Title: 'BigTable1'

Title UEscape: ?

where:

 

Output

Description

Table Dictionary Name: ^Z^Z ^Z^Z

Each ^Z represents an ASCII replacement character, 0x1A, used to replace the 4 untranslatable characters, .

Note: The system uses ^ to represent unprintable control characters.

Table SQL Name: U&"\FF83\FF70\FF8C
\FF9E\FF99"

The SQL Name begins with U& to indicate that it is a UNICODE delimited identifier, that is, it contains untranslatable characters.

The sequence \FF83\FF70\FF8C\FF9E\FF99 is the set of UNICODE identifiers for the 4 untranslatable characters, preceded by the default delimiter character, in this case, \.

The string is enclosed in quotation marks so that the delimiter characters it contains can be used in an SQL request.

Note: The system does not return the UEscape clause, which normally closes a UNICODE delimited identifier. If you want to use a UNICODE delimited identifier in an SQL request, you need to add the UEscape clause. See “Using an SQL Name or SQL Title Value in an SQL Request” on page 901.

Table UEscape: \

Indicates the delimiter character used to separate the UNICODE identifiers in the SQL Name.

Note: Output for title entries is similar, for example, Dictionary Title and SQL Title. SQL Titles are enclosed in single quotation marks.