Building and Using Data Tables › Consolidating Tables › What You Can Do

What You Can Do

You can process data from more than one input table in a single CA Culprit run by reading the data tables as one logical file with the TYPE=CONSOLIDATION option. In addition, rows can be selected with WHERE or SELECT/BYPASS criteria.

Table data can be consolidated from:

• The same dictionary
• Different dictionaries
• Different DDS nodes
• Different central versions

How to Do It

To consolidate tables:

1. Check the column definitions of each table to be used. The definitions must be identical.
2. Define each table on an INPUT parameter using the keywords listed in the table below.
   • TYPE=COPY must appear on the first INPUT parameter to identify the primary data table.

     The primary data table is the source for:

     • The generated PATH parameter and all necessary REC parameters for the run
     • The specification of selection criteria (SELECT/BYPASS or the WHERE clause)
   • TYPE=CONSOL must appear on subsequent INPUT parameters to identify the secondary data tables.

     The order of appearance of the INPUT parameters determines the processing order of the tables.

3. Specify the output by using:
   • An OUTPUT parameter, if needed
   • At least one type 5 parameter
   • Type 6, type 7, and type 8 parameters as needed.
4. Reference tables, if needed, in a table consolidation run by using the reserved words shown in the table below. These reserved words are valid on SELECT/BYPASS, edit, SORT, and process parameters.

Required Keywords:

TABLE=

The table name

TYPE=COPY/CONSOL

The primary and secondary tables to be consolidated

USER=

The individual having authority to sign on to the catalog (dictionary)

PW=

The user's password

OWNER=

The owner of the table

CATALOG=

The catalog or dictionary containing the table definition

Optional Keywords:

LOCATION=

Overrides DATABASE DICTNODE=

SYSCTL= (z/OS and OS/390 Users)

Names the SYSCTL file that controls the system accessing the table.

VALIDATE=FIRST/ALL

Compares column definitions of secondary tables to definitions of the primary table.

WHERE

Applies WHERE clause criteria to all tables being consolidated.

Reserved Words to Reference Tables