次のリクエストを実行してセッション属性を設定したとします。
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