The CDCSTCK function returns returns the eight (8) byte storeclock (STCK) value from a changed data capture (CDC) record in a 16 byte displayable hexadecimal character format. The value identifies the time (based on a 24 hour clock) that the update took place within a transaction or program. A human readable version of the Storeclock can be retrieved using the CDCTSTMP Function.
Category
Change Data Capture
Syntax
CDCSTCK(<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 value of the zOS storeclock from the current record in the source changed data capture (CDC) datastore CDCIN. Map the result to target field SRC_STCK.
SRC_STCK = CDCSTCK (CDCIN)Returns the value DA30F61838AF1E02.
Note:
- See STORECLOCK for more information including how to convert from and to the STCK value outside the product.
- Most zOS mainframe environments use UTC or Coordinated Universal Time (the abbreviation came about as a compromise between English and French speakers who preferred "Coordinated Universal Time - CUT" and "Temps Universel Coordonné - TUC". The International Astronomical Union wished to minimize confusion and designated the single abbreviation UTC for use in all languages. UTC does not favor any particular language and is consistent with the abbreviation for Universal Time, which is UT, with the variations UT0 and UT1. Connect CDC SQData cannot determine if UTC or a timezone was used when MVS was configured.
- This function replaces the IMSCDCSTCK and DB2CDCSTCK functions, although these functions are still supported in Connect CDC SQData V4.