15.00 - Nontemporal Operations - Teradata Database

Teradata Database Temporal Table Support

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1182-015K

Nontemporal Operations

To allow operations that are otherwise not allowed on tables with transaction time, statements can specify the NONTEMPORAL prefix. Such operations on tables with transaction time require the NONTEMPORAL privilege.

Here is an example that grants the NONTEMPORAL privilege to user simon573 on a transaction-time table named Policy_Types:

   GRANT NONTEMPORAL ON Policy_Types TO simon573;

To disable all nontemporal operations, use the EnabNonTempoOp field of the DBS Control utility.

For details on the DBS Control utility, see Utilities.