Please enable JavaScript to view this site.

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

Changed Data Capture

Syntax

CDCUID(<source_datastore>)

 

Parameter Descriptions

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)