17.05 - Nonsequenced Transaction-Time Queries - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

Nonsequenced transaction-time queries on transaction-time tables produce nontemporal tables as a result. Use the NONSEQUENCED TRANSACTIONTIME qualifier to query and compare across all transaction-time states simultaneously.

The nonsequenced query treats a transaction-time table as a table with a regular Period column with no special temporal semantics. References to the transaction-time column can appear anywhere in the query.

If the projection list specifies *, the transaction-time column is also projected.

If the query involves a bitemporal or valid-time table, refer to the following topics for additional information that applies to the valid-time dimension: