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 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/cvtdecdatetime.html