|
|
|
Any file data field or work field name can be specified. The maximum number of names is 32. All names must fit on one line; the real limit, however, is the size of the print line. CA JARS Wizard assumes the maximum print line size is 132 positions, unless the run includes a PARAMETER statement with a different WIDTH specification.
Enter the names in the order that the fields should appear in the report, from left to right. CA JARS Wizard automatically inserts blank spaces to separate fields in the report. In the LIST statement, names must be separated by commas.
A data field's name is also used as its column heading when printed in a report. The field can have more than one valid name because of a DEFINE statement in the run. The name in the LIST statement is used as the column heading.
A column heading can be one, two, or three lines in length. Names can be segmented into two or three lines by replacing any spaces in the field name by a slash (/). For example:
TEST FLAG appears as:
TEST FLAG
but
TEST/FLAG appears as:
TEST FLAG
An alternate column heading is specified by entering its text within single quote marks, immediately after the data field name.
For more information, see Appendix B for a discussion of suffix codes that can be used to specify or override print attributes of field-names.
causes CA JARS Wizard to insert n blanks between two adjacent fields. For vertical totals, use the appropriate suffix code to space n lines.
These suffix codes create vertical totals. Vertical totals are created for data fields at control breaks, but the fields are not included in either the detail or summary print line. The vertical totals for the fields are printed in column one after the regular line of control break totals.
Supplies totals for the field at every control break.
Supplies totals for the field only at specified control breaks. T1 is the lowest control break, and T8 refers to the highest control break.
Supplies totals for the field only with grand totals at the end of the report.
These suffix codes can be written following the LIST keyword. In this case, they apply to all items in the statement unless overwritten for an individual item by a different suffix.
The sample report on the next page illustrates the use of vertical totals.
Caution: If you use LIST field-name 'heading' (N,N), you will receive error messages. The correct format is: LIST field-name(N,N) 'heading'
CA DETAIL REPORT CA JARS Wizard PAGE 1 CA JARS Wizard 2.3 9710JW000 APPL NAME TOTAL APPLICATION ACCOUNTING DEPARTMENT TRAN CODE APQIOD TOT/TRAN/CNT 99,982 AVERAGE/RESPONSE/TIME 0.5 AVERAGE/CPU/TIME 0.027 TOT/DB/CALLS 1,678,839 TOT/MSG Q/ISRT 189,389 PGM/ABENDS 5 APPL NAME TOTAL APPLICATION LEGAL DEPARTMENT TRAN CODE LESIOE TOT/TRAN/CNT 45,892 AVERAGE/RESPONSE/TIME 1.5 AVERAGE/CPU/TIME 0.028 TOT/DB/CALLS 983,789 TOT/MSG Q/ISRT 38,290 PGM/ABENDS 9 APPL NAME TOTAL APPLICATION UNKNOWN TRAN CODE WHUSHJ TOT/TRAN/CNT 87,662 AVERAGE/RESPONSE/TIME 1.3 AVERAGE/CPU/TIME 0.034 TOT/DB/CALLS 2,364,125 TOT/MSG Q/ISRT 362,646 PGM/ABENDS 25 GRAND TOTAL APPLICATION UNKNOWN TRAN CODE WHUSHJ TOT/TRAN/CNT 233,536 AVERAGE/RESPONSE/TIME 1.0 AVERAGE/CPU/TIME 0.03 TOT/DB/CALLS 5,026,753 TOT/MSG Q/ISRT 590,325 PGM/ABENDS 39
The statements used to generate the vertical total lines after a change in X.APPL NAME (the control break in this example) are:
LIST X.APPL NAME'APPLICATION'(T), X.TRAN/ID'TRAN CODE'(T),
X.TOT/TRAN/CNT(L8)(T), AVG/RESP'AVERAGE/RESPONSE/TIME'(L4)(T),
AVG/CPU'AVERAGE/CPU/TIME'(L4)(T), X.TOT/DB/CALLS(L8)(T),
X.TOT/MSG Q/ISRT(L6)(T), X.PGM/ABENDS(L5)(T)
or
LIST(T) X.APPL NAME'APPLICATION', X.TRAN/ID'TRAN CODE',
X.TOT/TRAN/CNT(L8), AVG/RESP'AVERAGE/RESPONSE/TIME'(L4),
AVG/CPU'AVERAGE/CPU/TIME'(L4), X.TOT/DB/CALLS(L8),
X.TOT/MSG Q/ISRT(L6), X.PGM/ABENDS(L5)
| Copyright © 2012 CA. All rights reserved. |
|