Purpose
Determines whether NONTEMPORAL operations can be used.
NONTEMPORAL operations delete rows, modify history rows, or change Transaction Time column values on temporal tables that include a Transaction Time column. These operations include NONTEMPORAL DELETE, NONTEMPORAL UPDATE, NONTEMPORAL INSERT, NONTEMPORAL CREATE TABLE AS, and NONTEMPORAL ALTER TABLE.
The NONTEMPORAL privilege allows a user to circumvent the automatic history that is kept for tables with transaction time. It allows users to perform operations that would otherwise not be allowed on these tables. For purposes of data security and integrity, Teradata recommends that the EnabNonTempoOp setting remain unchanged from the default, so that NONTEMPORAL operations are blocked, unless absolutely necessary.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Nontemporal operations can be performed on temporal tables. |
| FALSE | Nontemporal operations cannot be performed on temporal tables. |
Default
FALSE
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
Leave this field set to FALSE to prevent inadvertent and unauthorized modifications to temporal tables that include transaction time. Enable this setting only when nontemporal operations are necessary, as for deleting very old history rows or fixing problems with temporal tables.
Related Topics
For more information on temporal operations, see Teradata Vantage™ - Temporal Table Support , B035-1182 .