Use the New Sequential Table wizard to map information from a copybook
to a new table for a sequential 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 filesystem.
- 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.
- 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.
Specify Sequential Information page
Use this page
to select an 01 level, to name the table, and to enter information to specify
the location of the file.
- Select 01 level
- If the copybook has more than one 01 levels, 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.
- 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.