15.00 - Temporal Behavior - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Temporal Behavior

Purpose  

Determines the default temporal behavior for temporal DDL, queries and DML statements.

Note: This setting 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.

1

Default temporal session qualifier is ANSIQUALIFIER, required to use ANSI-compliant temporal tables documented in ANSI Temporal Table Support.

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 Topics

    For more information on temporal tables and syntax, see ANSI Temporal Table Support and Temporal Table Support.