16.10 - Temporal Behavior - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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