Specifying the copybook

The next stage is to specify the data set copybook. When you specify S in Figure 2 you see the panel shown in Figure 1.

Figure 1. CICS VT auto mapping input panel
 
------------------ CICS VT: Auto mapping input for VIDKSDS  -------------------
Command ===> ________________________________________________ Scroll ===> CSR_ 
                                                                               
Mandatory fields:-                                                             
Copybook data set ===> CICSVT.LCN.COPYBOOK_____________________________________
Copybook member   ===> ________ (Blank or pattern for member selection list)   
Copybook language ===> C        (Assembler or COBOL or PL/I)                   
Zoned to DECIMAL  ===> Y        (Y/N, applies to unsigned zoned only)          
Review / edit DDL ===> Y        (Y/N)                                          
                                                                               
Table creator     ===> VID................................................... +
Table name        ===> VID_ITEM_TABLE........................................ +
Primary index     ===> VID_ITEM_INDEX........................................ +
Tablespace name   ===> VIDITTS_                                                
Database name     ===> VIDITDB_                                                
                                                                               
Optional fields:-                                                              
Copybook first field => _______________________________________________________
Copybook last field  => _______________________________________________________
                                                                               
DDL output data set  => _______________________________________________________
                                                                               
Press: Enter to continue   PF3 to exit   PF1 for help                          

The fields in the auto mapping input panel are as follows:

Table 1. Auto mapping input panel fields
Field Description
Copybook data set The name of the data set containing the copybook for this data set.
Copybook member The name of the copybook member. Leave this field blank for a member selection list.
Start of change Copybook language End of change Start of change Specify the first letter of the input copybook member language. Note that results are unpredictable if the incorrect language is specified. End of change
Zoned to DECIMAL Specify Y if you want unsigned zoned decimal fields to be mapped to DB2® DECIMAL columns. N will map the fields to CHAR columns.
Review / edit DDL Y takes you to the Edit columns screen. You can perform various tasks such as renaming or updating columns. N bypasses the Edit columns screen and submits the automated mapping batch jobs, but only if no user actions are required.
Table creator Specify the creator of the DB2 table and indexes. This field is scrollable.
Table name Specify the name of the DB2 table. This field is scrollable.
Primary index Specify the name of the primary index for the DB2 table. This field is scrollable.
Tablespace name The DB2 tablespace for the table. This defaults to the DIM name.
Database name The DB2 database for the tablespace. The database must already exist.
Copybook first field If the input copybook member contains multiple record layouts, specify the name of the first field (without the field level number).
Copybook last field Specify the last field name in the structure.
DDL output data set Specify the name of the sequential data set for the DDL that CICS® VT will generate for the DB2 objects. This data set should be saved in order to transfer the file to a different system. If the data set exists it is overwritten.

CICS VT does not allow mapping to proceed if any of the following conditions are detected:

Start of change

Assembler copybook notes

When the input copybook is in Assembler, the automated mapping facility assembles the copybook in foreground. If the return code from the assembly is not zero, the assembly analysis terminates, the assembly listing is written to a data set, and the dialog displays the listing.

If the copybook contains multiple DSECT statements, each structure is assumed to redefine the record.

End of change

Information Information

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtug_specify_copybook.html