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

To 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:
  1. Initialize the data area by executing the
    INIT AREA
    function of DBUTLTY.
  2. Code a control statement for DBUTLTY's
    LOAD AREA
    function. See the following z/OS example:
    LOAD AREA=CUS,DBID=010,FORMAT=EXTRACT,DDNAME=CUSDATA,TABLE=CUS
  3. 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 the
    LOAD AREA
    function of DBUTLTY.

Convert a Variable-Length VSAM File to One
Datacom/DB
Table

To convert a single VSAM file with variable-length records to a single
Datacom/DB
table, follow these steps:
  1. Initialize the data area by executing the
    INIT AREA
    function of DBUTLTY.
  2. Code the control statement for the
    LOAD AREA
    function 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.
    The
    FORMAT=
    VAR
    parameter is needed only on the initial load of the area; thereafter, the
    BACKUP AREA
    function produces a format acceptable as input to the
    LOAD AREA
    function using the
    FORMAT=
    BACKUP
    option
  3. Use the
    LOAD AREA
    function of the DBUTLTY to convert the data to that area directly from the VSAM file.