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.
------------------ 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:
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. |
![]() ![]() |
![]() ![]() |
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:
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.