HELP SESSION Examples | Teradata Vantage - 17.05 - Example: HELP SESSION for the Current User - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
English (United States)
Last Update

The following request reports the attributes of the session for the current user.


 *** Help information returned. One row.
 *** Total elapsed time was 1 second.

                       User Name DBC
                    Account Name DBC
                      Logon Date 15/01/29
                      Logon Time 20:01:09
                Current DataBase DBC
                       Collation ASCII
                   Character Set UTF8
           Transaction Semantics Teradata
                Current DateForm IntegerDate
               Session Time Zone -08:00
          Default Character Type LATIN
                    Export Latin 2
                  Export Unicode 3
           Export Unicode Adjust 0
                Export KanjiSJIS 1
                  Export Graphic 3
             Default Date Format YYYY/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
                            LDAP N
                  Audit Trail Id DBC
         Current Isolation Level SR
           Default BigInt format -(19)9
                      Proxy User
                      Proxy Role
                 Constraint1Name ?
                Constraint1Value ?
                 Constraint2Name ?
                Constraint2Value ?
                 Constraint3Name ?
                Constraint3Value ?
                 Constraint4Name ?
                Constraint4Value ?
                 Constraint5Name ?
                Constraint5Value ?
                 Constraint6Name ?
                Constraint6Value ?
                 Constraint7Name ?
                Constraint7Value ?
                 Constraint8Name ?
                Constraint8Value ?
              Temporal Qualifier ANSIQUALIFIER
                        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 ?
         Constraint2Name UEscape ?
 Constraint3Name Dictionary Name ?
        Constraint3Name SQL Name ?
         Constraint3Name UEscape ?
 Constraint4Name Dictionary Name ?
        Constraint4Name SQL Name ?
         Constraint4Name UEscape ?
 Constraint5Name Dictionary Name ?
        Constraint5Name SQL Name ?
         Constraint5Name UEscape ?
 Constraint6Name Dictionary Name ?
        Constraint6Name SQL Name ?
         Constraint6Name UEscape ?
 Constraint7Name Dictionary Name ?
        Constraint7Name SQL Name ?
         Constraint7Name UEscape ?
 Constraint8Name Dictionary Name ?
        Constraint8Name SQL Name ?
         Constraint8Name UEscape ?
                       Zone Name
                 SearchUIFDBPath ?
           Transaction QueryBand ?
               Session QueryBand ?
               Profile QueryBand ?
           Unicode Pass Through  F
If row-level security is disabled or if no constraint applies to the session, the constraint name and constraint value fields are NULL.