17.05 - Inserting into Load Isolated Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

The RowLoadID value in each row of a load isolated table records the LoadID value. The LoadID used in a newly inserted row is derived from the last committed LoadID value for the table as recorded in DBC.TVM.CurrentLoadId. For more information, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.

TD_ROWLOADID Expression

The TD_ROWLOADID expression reads the RowLoadID. The data type of the expression is BIGINT with a default format of '-(19)9'.

The TD_RowLoadID expression is not permitted in a JI definition, a partitioning expression, or a CHECK Constraint.

You specify the TD_RowLoadID expression as follows:

    database_name.table_name.TD_ROWLOADID
database_name
Name of the containing database, if other than the default database.
table_name
Name of a load isolated table.