CICS VSAM Transparency for z/OS, Version 1.2


Processing DATE columns in CICS VT exits

The CICS® VT SQL driver modules are precompiled with DATE and TIME options set to ISO.

This means that DATE and TIME column data is retrieved by CICS VT in the following formats:

  Format Example
DATE YYYY-MM-DD 2008-12-31
TIME HH:MM:SS 23:59:39

If you develop any CICS VT exits that process DATE or TIME column data retrieved by an SQL driver, the data will be in ISO format. This can be changed by updating the JCL used by the driver generation job. See member VIDPRE in my.SVIDCNFG.custom.



Concept topic


Last updated: February 8, 2013 20:44:3