15.00 - SET SESSION TTGRANULARITY TO - Teradata Database

Teradata Database Temporal Table Support

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

SET SESSION TTGRANULARITY TO

Purpose  

Can be used to set the granularity of timestamping used for rows in temporal tables with transaction time.

Syntax  

 

Syntax Element

Description

LOGICALROW

Row is timestamped with the time the row is processed by the AMP.

REQUEST

Row is timestamped with the time the request is submitted.

TRANSACTION

Row is timestamped with the time when the first non-locking reference is made to a temporal table, or when the built-in function TEMPORAL_TIMESTAMP is first accessed during the transaction.

Usage Notes  

SET SESSION TTGRANULARITY is effective only in Teradata session mode.

The setting of SET SESSION TTGRANULARITY does not persist across system restarts.

SS may be used as a synonym for SET SESSION.

Related Information

 

For more information on...

See...

Timestamping rows in temporal tables

“Timestamping” on page 27

Teradata Database session modes

SQL Fundamentals and
SQL Request and Transaction Processing