Scripting Guide

9.8.0

Back Next

Access to Metadata

: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.