CICS VSAM Transparency for z/OS, Version 1.2


Field level data reengineering by mapping

Most field level data reengineering is achieved by mapping. To illustrate this, look at the mapping for the sample VSAM data set provided with CICS VT, called VIDKSDS.

This is shown in Figure 1.
Figure 1. CICS VT sample VSAM file mapping
 ------------------- CICS VT: List of fields for VIDKSDS     Row 1 to 10 of 10 
Command ===> ________________________________________________ Scroll ===> CSR  
                                                                               
VSAM file type : KSDS     Creator   : CIRDL                                  + 
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                    +                   
_ VIDF001  00012 00007   C  ITEM_NAME                      +                   
_ VIDF002  00006 00019   C  ITEM_COLOUR                    +                   
_ VIDF003  00004 00025   C  ITEM_WEIGHT                    +                   
_ VIDF004  00004 00029   P  ITEM_COST                      +                   
_ VIDF005  00003 00033   C  ITEM_REORDER_NO                +                    
_ VIDF006  00003 00036   C  ITEM_SUPP_CODE                 +                   
_ VIDF007  00005 00039   P  ITEM_DATE_FSHIP                +           Y       
_ VIDF008  00002 00044   C  ITEM_SHELF_LIFE                +                   
_ VIDF009  00035 00046   C  ITEM_DESCRIPTION               +                   
******************************* Bottom of data ********************************
 

The data in the fields highlighted in Figure 1 is automatically reengineered due to the combination of the field attribute and the DB2 column data type.

The combination of copybook field type and the column type determines when data transformation occurs.



Concept topic


Last updated: December 6, 2013 20:45:2

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///topics/cvtdecfieldlevel.html