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
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2026
First publish date
2000
ft:lastEdition
2026-03-26
ft:lastPublication
2026-03-26T20:24:24.831000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC
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)
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