:META.REC.NUM_IN_TX

For Applier processing, returns the sequence number of a DML operation in a transaction.

For InitialSync processing, returns a null value.

:META.REC.OPTYPE

Returns a string that contains the DML operation type. For Applier processing, the operation type must be one of the following values:

I
for Inserts.
U
for Updates.
D
for Deletes.

For InitialSync processing, the operation type must be

O

for Inserts.

:META.REC.OBJID

For Applier processing, returns the integer value of OBJECT ID of the source table.

For InitialSync processing, returns a null value.

:META.REC.OBJ_DATA_ID

For Applier processing, returns the integer value of DATA OBJECT ID.

For InitialSync processing, returns a null value.

:META.REC.OP_DT

For Applier processing, returns the DATETIME object that contains the creation time of a record.

For InitialSync processing, returns a null value.

:META.REC.SCN

For Applier processing, returns a string that contains the SCN value for an added source record.

For InitialSync processing, returns a null value.

:META.TRANS.BEGIN_DT

For Applier processing, returns a string that contains the DATETIME value for opening a transaction in the source database.

For InitialSync processing, returns a null value.

:META.TRANS.BEGIN_SCN

For Applier processing, returns a string that contains the SCN value for opening a transaction in the source database.

For InitialSync processing, returns a null value.

:META.TRANS.END_DT

For Applier processing, returns a string that contains the DATETIME value for closing a transaction in the source database.

For InitialSync processing, returns a null value.

:META.TRANS.END_SCN

For Applier processing, returns a string that contains the SCN value for closing a transaction in the source database.

For InitialSync processing, returns a null value.

:META.TRANS.ID

For Applier processing, returns a string that contains the transaction ID in the source database.

For InitialSync processing, returns a null value.

:META.TRANS.STATE

For Applier processing, returns a string with a transaction state. Valid values are:

R
for rollback
A
for activated
C
for commit

For InitialSync processing, returns a null value.

:META.TRANS.USER_ID

For Applier processing, returns the user ID of the database user who performed a DML operation.

For Applier processing of change data from DB2 sources, returns a null value.

For InitialSync processing, returns a null value.

:META.TRANS.USER_NAME

For Applier processing, returns the name of the database user who performed a DML operation.

If the transaction logs do not contain the user name, returns a null value.

For InitialSync processing, returns a null value.

Metadata Operators in Audit and Merge Apply Modes