CICS VSAM Transparency for z/OS, Version 1.2


CICS VT mapping rules

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.

Figure 1. List of fields panel
 
--------------------- 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.





Last updated: February 8, 2013 20:42:57