Previous Topic: Sorting

Next Topic: Vertical Totals


Control Breaks and Group Totals

CA JARS Wizard can provide for up to eight control breaks and group totals. For example, an installation may want a report displaying CICS/VS activity by run date, transaction ID, and operator ID. It must also show transaction use count, CPU time, dispatch time, terminal input count, total file IOs, and average response time. The control statements and the report created by them are given below.

INPUT primary-input-file
SELECT PRO ID EQ ('S' OR 'T') AND STEP JOB IND EQ (' 1' OR '11')
SORT JOB/NAME, PROGRAM/NAME
BREAK JOB/NAME, PROGRAM/NAME
LIST JOB/NAME, PROGRAM/NAME, PER/GRP, CL, SERVICE/UNITS,
     CORE/USED(MX), STD LINES/PRNTD, DISK/IO/COUNT, NO/DK, NO/TP

 CA                                                        DETAIL REPORT  CA JARS Wizard 9710JW000                                                                 07 AUG 1998 12.05.35                                                                         MAX                          DISK                 JOB         PROGRAM     PER               SERVICE      CORE      STD LINES             IO     NO     NO                 NAME        NAME        GRP     CL          UNITS      USED          PRNTD          COUNT     DK     TP               --------     --------     ---     --     ----------     -----     ----------     ----------     --     --               ANDYBA       IDCAMS        16     K           4,190                        0              7      1      0                                                        ----------     -----     ----------     ----------     --     --               ANDYBA       IDCAMS                           4,190       252              0              7      1      0  PROGRAM NAME TOTAL               ANDYBA       IMASPZAP      16     K             841                        0             16      1      0               ANDYBA       IMASPZAP      16     K             994                        0             22      1      0               ANDYBA       IMASPZAP      16     K           1,063                        0             22      1      0                                                        ----------     -----     ----------     ----------     --     --               ANDYBA       IMASPZAP                         2,898        36              0             60      3      0  PROGRAM NAME TOTAL               ANDYBA                                        7,088       252              0             67      4      0   JOB NAME TOTAL               SCOTTF       CATMP          2                19,079                        0            129      4      0               SCOTTF       CATMP          2               209,747                        0          3,392     11      0               SCOTTF       CATMP          2                53,089                        0            520      5      0                                                        ----------     -----     ----------     ----------     --     --               SCOTTF       CATMP                          281,915       436              0          4,041     20      0  PROGRAM NAME TOTAL               SCOTTF       IEFBR14        1     A              45                        0              0      0      0               SCOTTF       IEFBR14        1     A              89                        0              0      0      0               SCOTTF       IEFBR14        1     A              90                        0              0      0      0               SCOTTF       IEFBR14        1     A             115                        0              0      0      0                                                        ----------     -----     ----------     ----------     --     --               SCOTTF       IEFBR14                            339         8              0              0      0      0  PROGRAM NAME TOTAL               SCOTTF                                      282,254       436              0          4,041     20      0   JOB NAME TOTAL               UNCATL       IEV90          1     A           5,181                        0            113      4      0                                                        ----------     -----     ----------     ----------     --     --               UNCATL       IEV90                            5,181     1,024              0            113      4      0  PROGRAM NAME TOTAL               UNCATL       IEWL           1     A             982                        0             13      2      0                                                        ----------     -----     ----------     ----------     --     --               UNCATL       IEWL                               982       264              0             13      2      0  PROGRAM NAME TOTAL               UNCATL                                        6,163     1,024              0            126      6      0   JOB NAME TOTAL     GRAND TOTAL                                           295,505     1,024              0          4,234     30      0

Highlights of the sample report are as follows:

The description of the BREAK statement identifies other facilities for the totals line and for page formatting.