Specifies time-dimension criteria for retrieving data from Teradata.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | CURRENT VALIDTIME (valid-time column) |
| CURRENT TRANSACTIONTIME (transaction-time column) | |
| Interaction: | Specifying values in a DATA step overrides LIBNAME values. |
| Data source: | Teradata |
| See: | TEMPORAL_QUALIFIER= data set option |
Table of Contents
selects rows that are valid at the current time.
selects rows with valid-time periods that overlap the specified AS OF period. For the period, you can specify either a single date or a time period (date range) by specifying a start date and an end date.
selects history, current, or future rows that are valid for the specified time period.
treats the table as nontemporal.
selects rows that are open in transaction time.
selects rows with transaction-time periods that overlap the specified AS OF period. For the period, you can specify either a single date or a time period (date range) by specifying a start date and an end date.
treats the table as nontemporal.
Use temporal qualifiers to specify time criteria for selecting data from temporal tables.
Temporal qualifiers that you specify in a LIBNAME statement apply only to that Teradata session and are implemented through session commands that are issued at connect time. For example, if you specify TEMPORAL_QUALIFIER='AS OF PERIOD '(1999-01-01, 2099-01-05)' ' in a LIBNAME statement, below is the Teradata SET SESSION command that is issued at connect time. The SQL is submitted as usual.
.SET SESSION ASOF PERIOD '(1999-01-01, 2099-01-05)'In this example, valid-time rows are selected for a specific date from the Mytest data set.
/* Consider data as of 2015-01-01. */
libname x teradata user=myusr1 pw=mypwd1 server=mysrv1
TEMPORAL_QUALIFIER='VALIDTIME AS OF DATE '2015-01-01' '
/* .SET SESSION VALIDTIME ASOF DATE'2015-01-01'; is issued
before submitting the SQL "Select * from mytest" */
proc print data=x.mytest;
run;