WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


New VSAM Table wizard

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.

Select Elements to Map to Columns page

Use this page to select the records that you want to map to columns in the logical table.

Default OCCURS processing options
Specify how to map record arrays. Your selection applies to the record arrays in the entire table. You can override this default by selecting an OCCURS statement and clicking Change OCCURS processing for the selected array.
Create record arrays
Specifies to map record arrays as arrays. This option is available if you chose to use the table for queries only, not for modifying data or for change capture.
Expand each occurrence
Specifies to map all arrays as sets of columns. The number of sets that are mapped for an array depends on the maximum number that is specified in the OCCURS statement for that array. For example, an array with three elements and five maximum occurrences is mapped into 15 columns: five sets of three columns.
Expand first occurrence
Specifies to map only the first occurrence of all arrays as sets of columns. For example, an array with three elements and five maximum occurrences is mapped into only one set of columns.
Find
Lets you search for text within the tree view.
Search flashlight
Click to search for the text that you entered in the Find field.
(Tree view)
Displays the elements for the selected record. Select elements to map to columns.
Expand all (Expand all)
Expands all nodes that are displayed in the tree view.
Collapse all (Collapse all)
Collapses all nodes that are displayed in the tree view.
Map the selected group element (Map the selected group element)
Highlight the parent element of a group of elements and click this icon to map the parent element to a column.
Change OCCURS processing for the selected array (Change OCCURS processing for the selected array)
Specifies the OCCURS processing options for a highlighted record array in the tree view.
Rename the selected element (Rename the selected element)
Opens the Rename window so that you can rename the highlighted element in the tree view.
Rename all elements (Rename all elements)
Opens the Rename All Elements window so that you can add prefixes and suffixes to the names of all of the elements or remove prefixes and suffixes.

Specify Search Condition for View page

If you chose to create a view, use this page to build the search condition for the WHERE clause in the subselect for the view.

View name
Provide a name for the view.
Table
The table lists the parameters that you create for the search condition.
Adds a criterion to the WHERE clause.
Adds a parameter to the search condition.
Deletes a criterion from the WHERE clause.
Deletes a parameter from the search condition.
Moves the criterion up.
Moves the parameter up.
Moves the criterion down.
Moves the parameter down.

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.



Feedback

Update icon Last updated: 2006-12-15