例: セッション属性に対するHELP SESSION - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
ft:locale
ja-JP
ft:lastEdition
2021-09-23
dita:mapPath
ja-JP/spp1591731285373.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

次のリクエストを実行してセッション属性を設定したとします。

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

次にHELP SESSIONリクエストを実行します。Vantageは次のレポートを返します。

          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