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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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

     SET SESSION SEQUENCED VALIDTIME PERIOD(DATE '2005-01-01', 
       DATE '2006-12-31') AND NONSEQUENCED TRANSACTIONTIME;

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