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.
------------------- 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.