例: 現在のユーザーに対するHELP SESSION - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
2021年1月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/ncd1596241368722.ditamap
dita:ditavalPath
ja-JP/ncd1596241368722.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

以下のリクエストは、現在のユーザーのセッションの属性を報告します。

HELP SESSION;

 *** 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
                         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 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
行レベルのセキュリティが無効な場合またはセッションに制約が適用されない場合は、制約の名前フィールドと制約値フィールドはNULLです。