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 Adabas tables and views for change capture

To capture changes from an Adabas database, you must create a relational table that maps to that database. You can also create a view on the table. Use the New Adabas Table wizard to create a table and a view.

Before you begin

Restrictions

About this task

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

Procedure

To create an Adabas table and optionally a view for change capture:

  1. Optional: Use the Adabas page of the Preferences window to set these default values:
    • The name of the Predict dictionary that you want to use.
    • The date format that Classic Data Architect should convert dates to.
    • The time format that Classic Data Architect should convert times to.
    • The maximum length for VARCHAR data.
    • The maximum length for LVARCHAR data.
    • The maximum number of occurrences for all fields that occur multiple times in an Adabas file.
    • Whether to use the User Synonym field from the Predict Dictionary when this field is defined.
  2. Map your Adabas database to a relational table by using the New Adabas 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 > Adabas table.
    2. Select the model and schema in which to create the table.
    3. Choose whether or not to create a view on the table.
    4. Choose either to connect to your Adabas database through an existing connection to a data server, or to create a new connection to a data server. Either data server must be configured to access the Adabas database.
    5. Specify the format of dates and times, the lengths of VARCHAR and LVARCHAR data types, and the maximum number of occurs. The default values that appear are either the global defaults that are set for the Adabas database or the defaults that are set in the Adabas page of the Preferences window.
    6. Specify that you want to use the table (and view, if you are creating one) for change capture.
    7. Provide either the Predict or Adabas information that is necessary for the discovery process.
    8. Select the Adabas fields to map to columns in your relational table.
    9. If you are creating a view, specify the criteria for the WHERE clause.
    10. Modify the names of columns and provide null values.
    When you finish the wizard, the new table appears under the selected schema. If you created a view, the view also appears under the selected schema.
  3. Optional: Modify the table properties or add privileges. Select the table and make any changes in the Properties view.
  4. 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 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 to open the DDL for editing.
  5. Optional: If you ran the DDL successfully on a data server, validate the table by running a test query against your Adabas 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.
  6. 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.
  7. Optional: If you ran the DDL successfully on a data server, validate the view by running a test query against your Adabas 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 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 CA-IDMS 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
Altering tables to support change capture
Altering views to support change capture
Related information
Views


Feedback

Update icon Last updated: 2006-12-15