The CDCRAW function returns the entire unaltered changed data capture (CDC) record from a CDC type datastore. This function is useful for routing CDC records to other Integration Engine instances. Note: The target field that you use to map the CDCRAW data into must be large enough to hold the complete CDC record. To calculate the correct length, take the length of the largest record that will be used with CDCRAW, multiply by 2 (for before and after image) and add 150 for the CDC header. Note: This function replaces the IMSCDCRAW and DB2CDCRAW functions, although these functions are still supported in Connect CDC SQData V4.
Category
Change Data Capture
Syntax
CDCRAW(<source_datastore>)
Parameter and Description
| Parameter | Description |
|---|---|
| source_datastore | The name of the source datastore that contains the changed data capture (CDC) records. |
Example
Retrieve the current, unaltered (raw) changed data capture (CDC) record from the source datastore CDCIN. Map the CDC record to target field TGT_CDC_RCD, which has been defined as 2000 character in length.
TGT_CDC_RCD = CDCRAW (CDCIN)