When you execute a HELP SESSION statement, the system returns 2 types of names, and where applicable, titles for database objects:
- Primary names and titles (for example User Name), according to the object definitions that exist in the data dictionary. The system substitutes error characters for any characters that are untranslatable into the session character set.
- A set of 3 additional fields associated with each name or title. For example: The 3 fields for User Name are:
- User Dictionary Name
- User SQL Name
- User UEscape
The 3 fields for a title (only for applicable objects, for example, tables and columns) are:
- Dictionary Title
- SQL Title
- Title UEscape
These fields help users to manage the differences between the data dictionary representation of name or title and the representation in the session (client) character set.
For the rules governing the content and use of name and title fields, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .
For example:
User Name DBC Account Name DBC Logon Date 13/01/31 Logon Time 02:12:56 Current DataBase DBC Collation ASCII Character Set ASCII Transaction Semantics Teradata Current DateForm IntegerDate Session Time Zone 00:00 Default Character Type LATIN Export Latin 1 Export Unicode 1 Export Unicode Adjust 0 Export KanjiSJIS 1 Export Graphic 0 Default Date Format YY/MM/DD Radix Separator . Group Separator , Grouping Rule 3 Currency Radix Separator . Currency Group Separator , Currency Grouping Rule 3 Currency Name US Dollars Currency $ ISOCurrency USD Dual Currency Name US Dollars Dual Currency $ Dual ISOCurrency USD Default ByteInt format -(3)9 Default Integer format -(10)9 Default SmallInt format -(5)9 Default Numeric format --(I).9(F) Default Real format -9.99999999999999E-999 Default Time format HH:MI:SS.S(F)Z Default Timestamp format YYYY-MM-DDBHH:MI:SS.S(F)Z Current Role Logon Account DBC Profile LDAP N Audit Trail Id DBC Current Isolation Level SR Default BigInt format -(19)9 QueryBand Proxy User Proxy Role Constraint1Name ? Constraint1Value ? Constraint2Name ? Constraint2Value ? Constraint3Name ? Constraint3Value ? Constraint4Name ? Constraint4Value ? Constraint5Name ? Constraint5Value ? Constraint6Name ? Constraint6Value ? Constraint7Name ? Constraint7Value ? Constraint8Name ? Constraint8Value ? Temporal Qualifier CURRENT VALIDTIME AND CURRENT TRANSACTIONTIME Calendar TERADATA Export Width Rule Set 1112211111222232222211121111112222322222 Default Number format FN9 TTGranularity LogicalRow Redrive Participation None User Dictionary Name DBC User SQL Name DBC User UEscape ? Account Dictionary Name DBC Account SQL Name DBC Account UEscape ? Current Database Dictionary Name DBC Current Database SQL Name DBC Current Database UEscape ? Current Role Dictionary Name ? Current Role SQL Name ? Current Role UEscape ? Logon Account Dictionary Name DBC Logon Account SQL Name DBC Logon Account UEscape ? Profile Dictionary Name ? Profile SQL Name ? Profile UEscape ? Audit Trail Id Dictionary Name DBC Audit Trail Id SQL Name DBC Audit Trail Id UEscape ? Proxy User Dictionary Name ? Proxy User SQL Name ? Proxy User UEscape ? Proxy Role Dictionary Name ? Proxy Role SQL Name ? Proxy Role UEscape ? Constraint1Name Dictionary Name ? Constraint1Name SQL Name ? Constraint1Name UEscape ? Constraint2Name Dictionary Name ? Constraint2Name SQL Name ?