Previous Topic: JARSWZ09 Execution Description

Next Topic: JARSWZ10 Control Statements


JARSWZ10: File Matching and Table Lookups

JARSWZ10 uses a secondary file to complete the information needed on a report. The report created is similar to the report created in JARSWZ11.

This example uses a secondary file in the following format:

Positions  1   : User information code
           2-21: Department name

CA JARS Wizard reads a primary input file record, reads the first position of the USER INFO field, finds a matching user information code in the secondary file, and prints the corresponding department name on the report.

                                                                                                             07 AUG 1994 PAGE    1                                                 FILE MATCHING: COST CENTER ANALYSIS                                                                                CPU       ACTIVE                                                                 TOTAL         TIME         TIME          TOTAL                            DEPT NAME          NBR JOBS       IO COUNT     HH.MM.SS     HH.MM.SS          PAGES                      --------------------     --------     ----------     --------     --------     ----------                      UNKNOWN DEPT CODE              88        286,753     01.26.25    124.54.59         22,375                      COMPUTER DEPT                   3            424     00.00.35     00.02.13            299                      PERSONNEL DEPT                  2          5,338     00.02.27     00.27.34          1,964                      OPERATIONS DEPT                 3          6,794     00.01.31     00.23.45          1,560                      PROGRAMMING DEPT            1,321      1,183,837     03.44.15    114.42.07         37,374                      MANAGEMENT DEPT               108         78,187     00.13.41     01.55.53            769                      MARKETING DEPT                460      2,035,195     04.58.44     29.08.19         20,925                      ADMINISTRATIVE DEPT           116        354,421     00.27.44     04.16.13            726                      SHIPPING DEPT                   1              9     00.00.07     00.00.17             42                      SYSTEMS DEPT                   17         13,134     00.35.19     01.01.20          3,178                      --------------------     --------     ----------     --------     --------     ----------   GRAND TOTAL                                    2,119      3,964,092     11.30.48    276.52.40         89,212