17.00 - Example: HELP SESSION for Session Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Assume you have submitted the following request to set the session attribute.


Then you submit a HELP SESSION request. Vantage returns the following report.

          User Name DBC
                Account Name DBC
                  Logon Date 02/05/11
                  Logon Time 11:43:09
            Current Database user_name
                   Collation CHARSET_COLL
               Character Set LATIN
       Transaction Semantics Teradata
            Current DateForm ANSI
           Session Time Zone -09:00
      Default Character Type UNICODE
                Export Latin 1
              Export Unicode 2
     Export Unicode Adjusted 2
            Export KanjiSJIS 1
              Export Graphic 2
          Export Width Rules 1112211111222232222211121111112222322222
         Default Date Format YYYY\u5E74MM\u6708DD\u65E5
             Radix Separator .
             Group Separator ,
               Grouping Rule 3
    Currency Radix Separator .
    Currency Group Separator ,
      Currency Grouping Rule 3
               Currency Name Yen
                    Currency \u00A5
                 ISOCurrency JPY
          Dual Currency Name Yen
               Dual Currency \u00A5
            Dual ISOCurrency JPY
      Default ByteInt format -(3)9
      Default Integer format G-(I)9
     Default SmallInt format G-(I)9
      Default Numeric format G--(I)D9(F)
         Default Real format G-9D99999999999999E-999
         Default Time format HH\u6642MI\u5206SSDS(F)\u79D2Z
   Default Timestamp format YYYY\u5E74MM\u6708DD\u65E5BHH\u6642MI\u5206SSDS(F)\u79D22Z
                Current Role Finance
               Logon Account user_name
                     Profile R&D
                        LDAP N
              Audit Trail ID ?
                  Proxy User ?
                  Proxy Role ?
     Current Isolation Level SR
       Default BigInt format -(19)9
                   QueryBand ?
             Constraint1Name LEVELS
            Constraint1Value 2
             Constraint2Name GROUPS
            Constraint2Value 1100
             Constraint3Name CATEGORIES
            Constraint3Value '90000000'xb
           Temporal Qualifier SEQUENCED VALIDTIME PERIOD(DATE '2010-01-01, 
                              DATE ‘2011-12-31' AND NONSEQUENCED TRANSACTIONTIME
               Calendar Name Teradata
       Redrive Participation