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.