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.