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 a separate table for each record array in a table definition

You can improve the performance of federated queries that read record array data if you map a separate table for each record array in the table definition.

Before you run the New Table wizard, import a data definition file into your data design project that describes the structure of the data in the source database, such as a COBOL copybook, a PL/I include file, or a CA-IDMS schema with subschemas. If your source is CA-IDMS or Adabas you can connect to the server to retrieve the information directly from the source database.

Each table you map separately consists of a single record array definition that contains the column definitions unique to a single array instance. Any given column appears in each instance of the array. For example, if your employee table has an array that describes employee dependents, the table structure might look like this:

KEY DEP_LAST_NAME DEP_FIRST_NAME DEP_GENDER DEP_ID DEP_DOB

You can map a separate table for each array by running the New Table wizard in Classic Data Architect once for each array, or you can copy and edit table objects as described in the following steps.

To map a separate table for each array in a base table by using the Data Project Explorer view:

  1. Run the New Table wizard once to create a parent table object.using the array processing option Create record array.
  2. Make one copy of the table object for each record array.
  3. Delete columns in each copied table object until the columns that remain contain the key information and array data that you want.
  4. Optional: Delete the columns that contain array definitions from the parent table if you want to use the non-array data for queries.
Related concepts
Performance considerations with multiple record arrays
Record array definitions for federation and change capture


Feedback

Update icon Last updated: 2007-10-09