17.10 - Temporal Behavior - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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 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.

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 Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182.