Example Object Name in HELP Output - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

For example, you have 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, .
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, \.

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

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.
Table UEscape: \ Indicates the delimiter character used to separate the UNICODE identifiers in the SQL Name.
Output for title entries is similar, for example, Dictionary Title and SQL Title. SQL Titles are enclosed in single quotation marks.