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


Creating CA-IDMS tables and views for change capture

To capture changes from a CA-IDMS database, you must create a relational table that maps to that database. You can also create a view on the table to filter record types or to filter rows and columns. Use the New CA-IDMS Table wizard to create the table and optionally the view.

Before you begin

Restrictions

About this task

In the New CA-IDMS Table wizard, you can map a single record or a specific path to as many as 10 records. You define a path by starting with a single record, and then navigating sets to additional records defined in the subschema. The subschema information that you use for mapping determines which records and sets are available. You can import the subschema information from a combination of CA-IDMS schema and subschema report files or directly from the CA-IDMS database by using Classic Data Architect's discovery process.

CA-IDMS schema and subschema reports are produced by running the CA-IDMS schema and subschema compilers and capturing the punched output into a z/OS® data set. JCL to punch these reports is in the SCACSAMP library with the member name CACIDPCH.

For more information about creating tables and views that map to CA-IDMS databases, see the related links for CA-IDMS syntax diagrams and for views.

Procedure

To create a CA-IDMS table and optionally a view for change capture:

  1. Map your CA-IDMS database to a relational table and optionally create a view by using the New CA-IDMS Table wizard.
    1. Open this wizard by right-clicking either the database in your data design project or one of the schemas within the database. Select Add Classic Object > CA-IDMS table.
    2. Select the CA-IDMS schema and subschema to base the table on.
    3. Specify that the table is for change capture.
    4. Choose whether to create a view on the table.
    5. Provide information that specifies how to access the CA-IDMS database.
    6. For each record in the path, specify a COBOL copybook, select an 01 level if there is more than one 01 level, and then select the elements to map as columns in your relational table. See Mapping CA-IDMS paths for change capture.
    7. Select the elements to map to columns in your relational table.
    8. If you are creating a view, specify the criteria for the WHERE clause.
    When you finish the wizard, the new table appears under the selected schema. If you created a view, it also appears under the selected schema.
  2. Optional: Modify the table properties or add privileges. Select the table and make any changes in the Properties view.
  3. Optional: Generate the DDL for the table. You can generate the DDL later, if you do not want to generate it now. You can also generate the DDL for all of the objects within the same schema. See Generating DDL.
    1. Right-click the table and select Generate DDL.
    2. In the Generate DDL wizard, follow these steps:
      1. Choose to generate CREATE statements.
      2. Choose to generate DDL for tables.
      3. Name the file in which you want to save the DDL within your project.
      4. Choose whether to run the DDL on a data server. After you run the DDL, check the Data Output view to determine whether the DDL ran successfully.
      5. Choose whether you want to open the DDL for editing.
  4. Optional: If you ran the DDL successfully on a data server, validate the table by running a test query against your CA-IDMS database. Be sure that the data server is connected to that database.
    1. In the Database Explorer, search your data server for the schema that you created the table in. Expand the schema and expand the Tables folder.
    2. Right-click the table and select Data > Sample Contents.
    3. Check the Data Output view to determine whether the test query ran successfully.
  5. Optional: If you created a view, generate the DDL for the view. You can generate the DDL later. You can also generate the DDL for all of the objects within the same schema. See Generating DDL.
    1. Right-click the view and select Generate DDL.
    2. In the Generate DDL wizard, follow these steps:
      1. Choose to generate CREATE and ALTER statements.
      2. Choose to generate DDL for views.
      3. Name the file in which to save the DDL within your project.
      4. Choose whether to run the DDL on a data server. After you run the DDL, check the Data Output view to determine whether the DDL ran successfully.
      5. Choose whether you want to open the DDL for editing.
  6. Optional: If you ran the DDL successfully on a data server, validate the view by running a test query against your CA-IDMS database. Ensure that the data server is connected to that database.
    1. In the Database Explorer, search your data server for the schema that you created the view in. Expand the schema and expand the Views folder.
    2. Right-click the view and select Data > Sample Contents.
    3. Check the Data Output view to determine whether the test query ran successfully.
Related concepts
Mapping data for change capture
Creating views on existing tables
Related tasks
Creating Adabas tables and views for change capture
Creating CICS VSAM tables and views for change capture
Creating IMS tables and views for change capture
Creating native VSAM tables and views for change capture
Mapping tables and views for redefined data
Altering tables to support change capture
Altering views to support change capture
Modifying the selection of records in tables for CA-IDMS databases
Related information
Views


Feedback

Update icon Last updated: 2007-10-09