The CDCEPOCH 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 and Description
| Parameter | Description |
|---|---|
| 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)