The CDCUID function returns the user ID of the individual/group that initiated the change to the source record within a transaction or program. This information is only available for changed data capture (CDC) records.
Note: This function replaces the IMSCDCUID and DB2CDCUID functions, although these functions are still supported in Connect CDC (SQData) V2.
Category
Change Data Capture
Syntax
CDCUID(<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 User ID from the current record in the source changed data capture (CDC) datastore CDCIN. Map the result to target field SRC_UID.
SRC_UID = CDCUID(CDCIN)