CICS VSAM Transparency for z/OS, Version 1.2


Date and time fields

The mapping in Figure 1 shows that the VIDF007 field in VIDKSDS has the picture string CCYYMMDD. You must always specify a picture string when you map a field to a DB2® column with a data type of DATE, TIME, or TIMESTAMP, unless you are using an FBE to perform the reengineering.

DATE columns are the most common. A windowing facility is provided, enabling transformation to occur for VSAM fields that do not include a century value. For example, assume you have a 4-byte packed decimal field containing date information, and you map it to a DATE column. There are two different ways that you can specify the picture string in the mapping, which are as follows:
YYMMDD
With this picture string, CICS® VT adds a century of 19 to every date value in DB2.
YnMMDD
With this picture string, CICS VT uses date windowing, where n represents a decade. If n = 4, dates containing a year value less than 40 will have a century of 20 in DB2. If n ≥ 4, CICS VT uses century = 19.
If your VSAM date field includes the century, such as VIDF0007 in the VIDKSDS sample file mapping in Figure 1, date windowing is not required.


Concept topic


Last updated: November 9, 2012 20:43:54