There are some mapping rules that CICS® VT imposes, which apply to mapping all supported data set types. The automated mapping feature applies these rules, but you must apply them when using the manual mapping method.
Figure 1 shows an example of the complete mapping data for the file VIDKSDS. The copybook and DDL for this file are shown in The mapping component.
--------------------- CICS VT: List of fields for VIDKSDS ------- Row 1 of 10
Command ===> ________________________________________________ Scroll ===> CSR_
VSAM file type : KSDS Creator : VID +
Data set length: 00080 Table name: VID_ITEM +
Actions: S Display, U Update, I Insert, D Delete
A Field Bytes Start Type DB2 column name Exit Pic Par
- -------- ----- ----- ---- ------------------------------ -------- --- ---
_ VIDKEY 00006 00001 C ITEM_NUMBER +
_ VIDM0002 00012 00007 C ITEM_NAME +
_ VIDM0003 00006 00019 C ITEM_COLOUR +
_ VIDM0004 00004 00025 C ITEM_WEIGHT +
_ VIDM0005 00004 00029 P ITEM_COST +
_ VIDM0006 00003 00033 C ITEM_REORDER_NO +
_ VIDM0007 00003 00036 C ITEM_SUPP_CODE +
_ VIDM0008 00005 00039 P ITEM_DATE_FSHIP + Y
_ VIDM0009 00002 00044 C ITEM_SHELF_LIFE +
_ VIDM0010 00035 00046 C ITEM_DESCRIPTION +
The mapping rules imposed by CICS VT are as follows:
Note that the Bytes, Start, and Type fields refer to the attributes of the copybook fields, not the DB2 column. For example, the copybook field ITEM-REORDER-QUANTITY, which is shown in Figure 2, has an attribute of PIC S999, which is 3 bytes. The field name generated by CICS is VIDM0006 and is mapped to column ITEM_REORDER_NO, which is SMALLINT with a length of 2 bytes in DB2.