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


Modifying the selection of records in tables for CA-IDMS databases

Use the Modify CA-IDMS Table wizard to change the selection of records in an existing table before the DDL for the table is run on a data server.

Before you begin

The subschema and schema reports that you select must be identical to the reports that you used when you created the table. However, the names of the files that contain those reports can be different from the names of the files that you originally used.

You can provide the information on which to base the logical table in one of two ways:
  • You can import schema and subschema files that were punched from the CA-IDMS dictionary and transferred via FTP to your workstation. These files must be located in the CA-IDMS References folder of your data project.
  • You can tell Classic Data Architect to obtain the schema information that is associated with all records, sets, and areas that are listed in the required subschema directly from the CA-IDMS dictionary.

You produce CA-IDMS schema and subschema reports by running the CA-IDMS schema and subschema compilers and capturing the punched output into a z/OS® data set. Sample JCL that you can use to punch these reports is in member CACIDPCH of the SAMPLIB data set.

Procedure

To modify the selection of records in an existing table for a CA-IDMS database:

  1. Open the Modify CA-IDMS Table wizard by right-clicking the logical table that you want to modify and selecting Modify CA-IDMS table.
  2. In the wizard, modify the selection of records:
    1. On the first page, verify that Classic Data Architect is getting the schema and subschema information from the correct location. If you are using local files that contain the subschema and schema reports and you want to use different files, browse your CA-IDMS References folder for the new files. The subschema and schema reports in those files must be identical to the reports that you used when you created the table.
    2. On the second page, you can modify the information that helps the data server locate the data structures in your database, and you can change the way that the table will be used.
    3. On the third page, you can rename the table. You can also modify the path of up to ten records and sets from which you want to choose the elements that will constitute the columns in your table.
    4. Complete a separate wizard page for every record and set that you include in the path to select the elements that you want to map to columns in the table.
    5. On the summary page, verify that the table contains the columns that you want. Click Finish to generate the model for the table.
Related tasks
Adding or replacing columns in tables based on data definition files
Creating CA-IDMS tables and views for change capture
Creating CA-IDMS tables and views for Classic federation
Related reference
Column properties
Database properties
Publication properties
Publishing map properties
Table properties
View properties
Index properties
Stored procedure properties


Feedback

Update icon Last updated: 2007-10-09