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.