Connect CDC SQData

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

Changed Data Capture

Syntax

CDCSTCK(<source_datastore>)

 

Parameter Descriptions

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)

 

That might return the value:

 

DA30F61838AF1E02

 

See CDCTSTMP for a continuation of this example

Notes:

1.See STORECLOCK for more information including how to convert from and to the STCK value outside the product.

2.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.

3.This function replaces the IMSCDCSTCK and DB2CDCSTCK functions, although these functions are still supported in  Connect CDC SQData V4.