Please enable JavaScript to view this site.

The CDCEPOCK function returns the number of seconds since Jan 1st 1970 from the changed data capture (CDC) record in a CDC type datastore. The epoch value reflects the time that the data was changed within a transaction or program.

Category

Change Data Capture

Syntax

CDCEPOCH(<source_datastore>)

 

Parameter Descriptions

source_datastore -The name of the source datastore that contains the changed data capture (CDC) records.

Example

Retrieve the Unix epoch value from the current record in source changed data capture (CDC) datastore CDCIN. Map the result to target field SRC_EPOCH.

SRC_EPOCH = CDCEPOCH (CDCIN)