Connect CDC SQData

@BEFORE

Returns the before image of a source field from changed data capture (CDC) records. Replaces functionality of both the CDCBEFORE and MAP_BEFORE functions.

CDCEPOCH

Returns Unix Epoch representation of the timestamp associated with a changed data capture (CDC) records only

CDCOP

Returns the change operation of the change data capture (CDC) record (generally I, U or D)

CDCRAW

Returns the entire unaltered changed data capture (CDC) record from a CDC type datastore

CDCSTCK

Returns Storeclock value from changed data capture (CDC) records in a displayable hexadecimal character format of 16 bytes

CDCTSTMP

Returns a 26 byte timestamp derived from the Storeclock value in changed data capture (CDC) records

CDCTSTMPPK

Returns a 20 byte packed (without punctuation) timestamp derived from the Storeclock value in changed data capture (CDC) records

CDCUID

Returns the user ID that changed a source record in changed data capture (CDC) records

CDCUOW

Returns the unit-of-work identifier (UOW ID) also referred to as the recovery token, for changed data capture (CDC) records

DB2QUAL

Returns the qualifier or schema of the DB2 table for changed data capture (CDC) records

DB2TBLNAME

Returns the name of the DB2 table for changed data capture (CDC) records

IMSDBDNAME

Returns name of the IMS DBD for changed data capture (CDC) records

IMSPGMNAME

Returns the name of the IMS program that made the change to the source data

IMSPSBNAME

Returns name of the IMS PSB used to make the change to the source data

IMSSEGNAME

Returns name of the IMS Segment for changed data capture (CDC) records

IMSTRANNAME

Returns name of the IMS transaction used to make the change to the source data

RECNAME

Returns the alias of the object associated with the current record of an input datastore