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.
|0||Default temporal session qualifier is CURRENT VALIDTIME AND CURRENT TRANSACTIONTIME, compatible with Teradata’s original implementation of temporal tables and syntax documented in Teradata Vantage™ - Temporal Table Support, B035-1182.|
|1||Default temporal session qualifier is ANSIQUALIFIER, required to use ANSI-compliant temporal tables documented in Teradata Vantage™ - ANSI Temporal Table Support, B035-1186.|
- 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.
For more information on temporal tables and syntax, see Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182.