When you execute a HELP statement, the system returns the following name and title information for database objects.
For names, such as column names:
- Primary name, for example, Column Name, based on object definitions that exist in the data dictionary. CHAR(30) name format for support of legacy applications.
- Column Dictionary Name
- Column SQL Name
- Column Name UEscape
For titles of objects which support a title, such as tables and columns:
- Title, up to VARCHAR(256)
- Dictionary Title
- SQL Title
- Title UEscape
These fields help you to manage the differences between the data dictionary representation of name or title and the representation in the session (client) character set. You can use SQL Name and SQL Title values directly in subsequent SQL statements.
The system determines the contents of HELP name fields based on the rules in the following table.
||The data dictionary name or title, translated to the session character set.
Object names: VARCHAR(128)
If any character in the name or title is not translatable into the session character set, the system converts it into the replacement character for the session character set.
For example, when the session character set is ASCII, the system replaces each untranslatable character with the SUBSTITUTE character 0x1A:
where the ^Z is used to represent an unprintable control character.
||The name or title as it exists in the data dictionary, converted to a string that can be directly used in an SQL request, expressed in the shortest form (with matching case) for the current session character set.
Object Names: VARCHAR(644)
If all characters in an object name are translatable into the session character set, the SQL Name for the object name is the same as the Dictionary Name. If SQL statement syntax requires quotation marks, the SQL Name field begins and ends with QUOTATION MARK (U+0022) characters.
For information on using quotation mark characters with object names, see SQL Fundamentals.
If the object name contains characters that are not translatable into the current session character set, the system expresses the SQL Name as a UNICODE delimited identifier, although without the normal closing UEscape clause, starting with LATIN CAPITAL LETTER U (U+0055), followed by AMPERSAND (U+0026), followed by QUOTATION MARK (U+0022), and ends with a QUOTATION MARK (U+0022).
The system expresses the SQL Title similarly to the SQL Name, except that a title is a string, not a name, so:
The system replaces each character that is not translatable into the session character set with the corresponding UNICODE identifier. Each UNICODE identifier is preceded by the default delimiter character for the session character set.
For example, when specifying the Polish currency as ‘Polish_Zloty,’ the LATIN SMALL LETTER L WITH STROKE, shown as an “l” in “zloty’ is expressed as \0142, for example:
Indicates the delimiter character that precedes each UNICODE identifier substituted for an untranslatable character in the SQL Name/SQL Title. For example:
Table UEscape: \
If all characters in the SQL Name/SQL Title are translatable into the session character set, the SQL Name/SQL Title field e does not include any delimiters and the UEscape field is NULL.
Table UEscape: ?
where the ? character represents NULL.