Convert a Single VSAM File to a Single Datacom/DB Table
Learn how to convert a single VSAM file of variable-length or fixed-length records to a single Datacom/DB table with Datacom VSAM Transparency.
Convert a Fixed-Length VSAM File to One Datacom/DB Table
Datacom/DB
TableTo convert a single VSAM file that is composed of fixed-length records to a single
Datacom/DB
table, proceed as follows. This procedure applies to files that are composed of a single record type and to files that are composed of multiple record types, where all record types have the same length. Follow these steps:
- Initialize the data area by executing theINIT AREAfunction of DBUTLTY.
- Code a control statement for DBUTLTY'sLOAD AREAfunction. See the following z/OS example:LOAD AREA=CUS,DBID=010,FORMAT=EXTRACT,DDNAME=CUSDATA,TABLE=CUS
- Convert the data to that area from the sequential backup file (or the source VSAM file if you did not create a backup) by using theLOAD AREAfunction of DBUTLTY.
Convert a Variable-Length VSAM File to One Datacom/DB Table
Datacom/DB
TableTo convert a single VSAM file with variable-length records to a single
Datacom/DB
table, follow these steps:
- Initialize the data area by executing theINIT AREAfunction of DBUTLTY.
- Code the control statement for theLOAD AREAfunction of DBUTLTY.DBVVRPR is defined as the user compression exit for the specified table. These specifications apply to any table composed of a single record type that is variable in length and to any table that is composed of multiple record types of different lengths.TheFORMAT=VARparameter is needed only on the initial load of the area; thereafter, theBACKUP AREAfunction produces a format acceptable as input to theLOAD AREAfunction using theFORMAT=BACKUPoption
- Use theLOAD AREAfunction of the DBUTLTY to convert the data to that area directly from the VSAM file.