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