Determines the default temporal behavior for temporal DDL, queries and DML statements.
This field should be changed only under the direction of Teradata Support Center personnel or field engineers.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 0 | Default temporal session qualifier is CURRENT VALIDTIME AND CURRENT TRANSACTIONTIME, compatible with Teradata’s original implementation of temporal tables and syntax documented in Temporal Table Support, B035-1182. |
| 1 | Default temporal session qualifier is ANSIQUALIFIER, required to use ANSI-compliant temporal tables documented in ANSI Temporal Table Support, B035-1186. |
Default
- 0 for systems that were upgraded from releases prior to Teradata Database Release 15.0, and that had the Teradata Temporal feature enabled.
- 1 for all other systems.
Changes Take Effect
After the DBS Control Record has been written.
Related Information
For more information on temporal tables and syntax, see ANSI Temporal Table Support, B035-1186 and Temporal Table Support, B035-1182.