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 Concept

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtdecprocessdate.html