Primary Key, Primary Fields and Primary Lines in Report Generation

The user can define up to two lines that comprise the report output (meaning, the user determines which fields are included in the report lines).

Many fields in a report maintain the same value for many records (for example, vault name for a multi-volume group). These fields are called primary fields and one of them is the primary key. (The field that is the primary key and the fields that are the primary fields are determined by the type of report being created.)

By setting parameter ID to P (Primary) or S (Secondary), the user can designate a report line as a primary line. Primary lines are only printed when the primary key changes value.

The primary key and the primary fields are determined as follows:

• In the GENERAL report, the primary key is determined by the PATH parameter specified in the EXTRACT statement.

  If PATH is set to VOLUME/ALLDATASETS or to VOLUME/FIRSTDATASET, the primary key is the volser and the primary fields are the fields extracted from volume record.

  If PATH is set to DATASET/ALLVOLUMES or to DATASET/FIRSTVOLUME, the primary key is the volser and sequence number of the data set; and the primary fields are the fields extracted from the data set record.

• In the DISTRIB report, the primary key is the volser of the volume (or the volser of the first volume in a multi-volume chain) and the primary fields are the fields that have the same value for all volumes in the chain (for example, From Location and To Location) and the fields extracted from the data set record that determined the vaulting pattern.
• In the SCRATCH report, the primary key is the volume’s volser (or the first volume’s volser in a multi-volume chain) and the primary fields are the fields extracted from the expiration data set record.