Use the New VSAM Table wizard to map information from a copybook
to a new table for a native VSAM file.
The copybook from which you want to create a table must be listed
in the COBOL Copybooks folder in your data project.
Specify Location and COBOL Copybook page
Use this
page to select the database model and the schema that you want to create the
table in. Also, use this page to select the copybook on which to base the
table.
- Database model
- Type the path and name of the database model in
which you want to create the table. For example, if your project is named
MyProject and your database model is named MyModel, type \MyProject\MyModel.
You can click Browse to select a database model.
- Copybook
- Type the path and name of the copybook on which
you want to base your table. For example, if your project is named MyProject
and your copybook is named copybook1, type \MyProject\copybook1.
You can click Browse to select a copybook that is located
on your file system.
- Schema name
- Select the schema in which you want to create
the table, or type a new schema.
- Select table usage
- Specify how the table will be used.
- Query
- Specifies that the table will be used for retrieving
data by Classic Federation.
- Update
- Specifies that the table will be used for updates
of data by Classic Federation.
- Change capture
- Specifies that the table will be used as a source
table for a publication or a subscription.
- Create view
- Use these controls to indicate whether you want to create a view on the
table.
- No
- Specifies that you do not want to create a view.
- Yes
- Specifies that you want to create a view on the table. This option allows
you to create a view for Classic Federation. You can use the view to filter
record types and to filter rows and columns.
- Yes with change capture
- Specifies that you want to create a view on the table. This option allows
you to create a view for change capture. You can use the view to filter record
types and to filter rows. The view must reference all of the columns that
are in the table.
Specify VSAM Information page
Use this page to select
an 01 level, to name the table, and to enter information to specify the location
of the VSAM file.
- Select 01 level
- If one copybook contains more than one 01 level,
select the 01 level that contains the elements that you want to map as columns
in the table.
- Table name
- Type a name for the table that you want to create.
By default, the wizard uses the name of the 01 level that you specify. You
can change this default.
- XM URL
- Displays the name of the data space and the name of the Cross Memory (XM)
queue to use. You can change this value. The change-capture agent that is
capturing changes to the native VSAM table writes change data to this XM queue.
The
format of the XM URL is XM1/name_of_data_space/name_of_queue
An
XM URL is required if you plan to use the table for change capture.
- Data set
- Use these controls to specify the data set in which the information for
the table is located.
- DS
- Specifies that the information from which to create
the table is contained in a data set.
- DD
- Specifies that the information from which to create
the table is contained in a data set with a DD name.
- Name
- Type the name of the data set or DD card in which
the information for the table is located.
- Record exit
- Optional: Use these controls to pass control to a record exit for decompressing
sequential records. You can use record exits only for Classic federation.
- Exit name
- Type a short native identifier for the name of
a record processing exit to invoke to decompress sequential records when the
file is accessed. The exit must either exist in a data set that is referenced
by the server's STEPLIB DD statement or reside in the link pack area. The
exit name follows z/OS® load module naming conventions.
- Maximum length
- Type the maximum length (in bytes) of the buffer
that is needed by the record exit to decompress a record.
- Comments
- Type any comments that you want to associate with
the table, such as the time and date that you created it and what records
it contains.
Summary page
Use this page to verify the columns
of the table that will be created when you generate and run the DDL.
If
you are creating a view on the table, you can view the SELECT statement that
Classic Data Architect will base the view on.
You can click Finish to
generate the model for the table.