CICS VSAM Transparency for z/OS, Version 1.2


Specifying data set details

After adding the new data set VIDKSDS to CICS® VT, select it for mapping by specifying S on the command line. For a new data set the following screen is shown:

Figure 1. Insert attributes for a new data set
 
------------------- CICS VT: Data set mapping for VIDKSDS  -------- Row 1 of 1 
Command ===> _______________________________________________ Scroll ===> CSR_  
                                                                               
Commands: I - Insert                                                           
Actions:  U - Update                                                           
          F - Show field information                                           
          D - Delete                                                           
                                                                               
Act File type                                               Status             
--- --------- --------------------------------------------- -------------------
******************************* Bottom of data ********************************

Start of change The first time you process a data set, the message Select the insert command to add details for a new data set is displayed. Specify I on the command line to display the following screen. End of change

Figure 2. Insert file details panel
  
--------------------- CICS VT: Insert data set information --------------------
 Command ===> ________________________________________________ Scroll ===> CSR_ 
                                                                                
 DIM name: VIDKSDS                                                         
                                                                                
                                                                                
 File information:                                                              
                                                                                
   VSAM filetype  .  ===> KSDS               (KSDS,KSDV,RRDS,RRDV)              
   Record length ..  ===> 00080              (Maximum in bytes)                 
   Fill character .  ===> __                 ("FF","00",blank)                  
                                                                                
 CICS VT information:                                                           
                                                                                
   DB2 table:             (Look-up available)                                   
     Table creator   ===> VID................................................. +
     Table name . .  ===> VID_ITEM............................................ +
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
 Press: Enter=Update  PF3=Exit                                                  

The information that you must specify is as follows:

Table 1. Required information
Field Description
VSAM filetype Specify one of the displayed values, depending on the type of file and whether it is fixed or variable length.
Record length The maximum length of the record. Do not include the length of the RRN prefix for an RRDS or RRDV file type.
Fill character If there are obsolete fields that you are not going to migrate to DB2® , the value returned by CICS VT for these fields is the fill character.
Table creator The SQL authorization ID of the DB2 table for this data set. (This is the value of the CREATOR column in SYSIBM.SYSTABLES.) This is a scrollable field.
Table name The name of the DB2 table for this data set (This is the value of the column NAME in SYSIBM.SYSTABLES). This is a scrollable field.

CICS VT verifies that the DB2 table exists by checking the DB2 catalog. CICS VT also uses this table for column lookup during field mapping.





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