Purpose
Identifies the name and owner of a table or a view of a table, as well as other options associated with the table.
Syntax
►►─── INput ─┬───────────────┬─ TABLE = entry-name ───────────────────────────► └─ record-size ─┘ ►─┬─────────────────────────┬────────────────────────────────────────────────► └─ TYPE = ─┬─ COPY ─────┬─┘ └┬─ CONSOL ─┬┘ └─ CONCAT ─┘ ►─┬────────────────────┬──┬─────────────────┬──┬──────────────────────┬──────► └─ USER = user-name ─┘ └─ PW = password ─┘ └─ OWNER = owner-name ─┘ ►─┬──────────────────────────┬──┬────────────────────────────┬───────────────► └─ CATALOG = catalog-name ─┘ └─ LOCATION = location-name ─┘ ►─┬────────────────────────┬──┬────────────────────────────┬─────────────────► └─ SYSCTL = sysctl-name ─┘ └─ CVMACH = cv-machine-name ─┘ ►─┬────────────────────────────┬──┬─────────────────────────────┬────────────►◄ └─ VALIDATE = ─┬─ FIRST ◄ ─┬─┘ └─ WHERE boolean-expression ──┘ └─ ALL ─────┘
Syntax Rules
Specifies the type of parameter. It must start in column 2.
In a CA Culprit run that consolidates tables, the table named on the first INPUT parameter is the primary table. CA Culprit uses the primary table to:
Tables named on subsequent INPUT parameters are secondary tables. The column definitions of each secondary table must be identical to those of the primary table.
Specifies the row length of the table. It must be an integer in the range 1 through 32,760. The following considerations apply:
Specifies the name of a table. TABLE = must be the first keyword coded on the INPUT card. Entry-name is a 1- to 64-character alphanumeric expression. If the name contains embedded blanks or special characters such as punctuation marks or symbols, it must be enclosed in single quotation marks. The following rules apply:
IN TABLE='MZC.REPTS85.BUDGET'
IN TABLE=MZC. $ Owner.Folder.Object * REPTS85 $ Note that the period * .BUDGET $ can appear on either line
Specifies the primary and secondary tables to be consolidated:
Identifies the individual with authority to sign on to the catalog and overrides the user specified on the PROFILE parameter, if any. User-name is a 1- to 32-character value.
Is the user's 1- to 8-character alphanumeric password. It overrides the password specified on the PROFILE parameter.
Identifies the table owner. When the user is not the table owner, this keyword expression is required. CA Culprit determines whether the owner has assigned the user passkey authority to read the table.
Identifies the catalog (dictionary) containing the table definition. This keyword allows you to specify a different catalog than the one given on the DICTNAME= clause of the DATABASE parameter. Consequently, you can consolidate data tables from any number of catalogs (dictionaries).
Catalog-name is a 1- to 8-character alphanumeric expression. If specified, catalog-name overrides the dictionary specified on the DATABASE parameter. If catalog-name is not specified, the default is as follows:
(DDS users only) Identifies the DDS node used to access the catalog containing the table. This keyword expression allows you to consolidate data tables from any number of nodes in a given DDS network.
Location-name is a 1- to 8-character value. The default is the value specified in the DICTNODE= keyword expression on the DATABASE parameter.
(z/OS and z/VSE users only) Overrides the SYSCTL= clause on the DATABASE parameter. If there is no sysctl value on the DATABASE parameter, CA Culprit uses the default value in IDMSOPTI. The SYSCTL= keyword expression allows users to consolidate tables from any number of DC/UCF systems.
(z/VM users only) Overrides the value of the CVMACH= clause on the DATABASE parameter and the central version specified in an IDMSOPTI module. Cv-machine-name is a 2- through 8-character value that identifies the virtual machine in which the IDMS-CV system is executing. With this keyword expression, CA Culprit can consolidate tables from any number of central versions in the same CA Culprit job step.
Compares either the first column or all columns of the secondary tables to the columns in the primary table:
Validates the first column in every secondary table to the first column in the primary table. CA Culprit compares the columns' offset, size, usage mode, data type, and decimal point.
FIRST is the default.
Validates the compatibility of every column in the secondary tables to every column in the primary table.
Applies WHERE clause criteria to all tables being consolidated. The WHERE criteria, if specified, must appear after all keyword expressions coded for the primary table (that is, the first INPUT parameter).
For syntax rules that apply to the WHERE clause, see PATH Parameter.
For the expanded syntax for boolean-expression, see SELECT / BYPASS — Overview.
Usage
CA Culprit produces a validation report in the Input Parameter Listing, as shown in the following figure. The report indicates column definitions in secondary tables that do not match the definitions of the primary table. If FIRST is the option specified, only the definition of the first column appears in the report; if ALL is specified, any of the column definitions can appear in the report.
VALIDATE COLUMN TABLE-ID COLUMN POSITION IN INTERNAL USAGE DATA DECIMAL FIELDS NUMBER NAME DATA RECORD SIZE MODE TYPE POINTS ******** 001 001 DEPT-NAME-0410 00001 0045 DISPLAY TEXT 001 002 DEPT-ID-0410 00001 0005 DISPLAY TEXT E C220002 FIELD INCOMPATIBLE WITH PRIMARY TABLE **** 002 001 EMP-ID-0415 00046 0006 DISPLAY TEXT 002 002 DEPT-NAME-0410 00006 0045 DISPLAY TEXT E C220002 FIELD INCOMPATIBLE WITH PRIMARY TABLE ***** **** 003 001 EMP-NAME-0415 00052 0025 DISPLAY TEXT 003 002 EMP-ID-0415 00051 0006 DISPLAY TEXT E C220002 FIELD INCOMPATIBLE WITH PRIMARY TABLE ***** **** 004 002 EMP-NAME-0415 00057 0025 DISPLAY TEXT E C220001 NO CORRESPONDING FIELD ON PRIMARY TABLE 005 002 SALARY-AMOUNT-0420 00082 0014 DISPLAY TEXT E C220001 NO CORRESPONDING FIELD ON PRIMARY TABLE
Examples
Example 1: Consolidating Three Data Tables
DATABASE DICTNAME=ASFDICT PROFILE USER=DJM PW=WALNUT INPUT TABLE=ACCOUNTING TYPE=COPY VALIDATE=ALL * WHERE EMP-NAME-0415 LE 'M' INPUT TABLE=PERSONNEL TYPE=CONSOL INPUT TABLE='PUBLIC RELATIONS' TYPE=CONSOL
In this example, CA Culprit consolidates tables for the Accounting, Personnel, and Public Relations departments. The DATABASE and PROFILE parameters provide the name of the catalog that contains the table definitions, the user's ID and the user's password. At run time, CA Culprit also determines that the user is also the owner of the tables.
The ACCOUNTING table is the primary table. The VALIDATE= keyword expression instructs CA Culprit to compare the column definitions in each of the secondary tables to the column definitions in the primary table. The WHERE clause selects only those rows in each table where the name of the employee begins with a letter less than or equal to 'M'.
Example 2: Using Multiple Dictionaries
IN TABLE=ACCOUNTING TYPE=COPY USER=LSB PW=PECAN * CATALOG=ASFDICT SYSCTL=SYSTEM85 IN TABLE='INTERNAL SOFTWARE' TYPE=CONSOL * USER=LSB PW=PECAN OWNER=MCK * CATALOG=TESTDICT SYSCTL=SYSTEM91
In this example, ACCOUNTING resides in dictionary ASFDICT in a DC/UCF system called SYSTEM85. INTERNAL SOFTWARE resides in the TESTDICT dictionary on SYSTEM91. The SYSCTL= keyword values refer to ddnames that appear in a z/OS or z/VSE JCL stream; in z/OS, for example:
//SYSTEM85 DD DSN=DBDC.SYSTEM85.SYSCTL,DISP=SHR //SYSTEM91 DD DSN=DBDC.SYSTEM91.SYSCTL,DISP=SHR
|
Copyright © 2014 CA.
All rights reserved.
|
|