Change Data Capture (CDC) - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
ft:lastEdition
2024-07-30
ft:lastPublication
2024-07-30T20:19:56.898694
Function Description
@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 (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
IMSDBNAME 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