DETAIL (tabulate and summarize each record)
DETAIL requests a tabular summary at each control break based on the first variable mentioned in the USING statement that precedes it.
A count is maintained for each item that has a common value matching the first variable. When the value of the first variable changes, a control break occurs and the totals and averages are printed. If neither SUMMARY nor DETAIL is used, a tabular report with no control breaks is printed.
Syntax
DETAIL
Usage
DETAIL can be coded only after the USING statement but prior to REPORT. If ORDER BY is used, DETAIL must follow this statement.
The report shown in in the following figure is produced when the following PRL is executed:
SET TITLE = 'DETAIL TRANSACTION ROSTER'
SELECT TYPE 6E RECORDS FROM CMRDETL
USING CMRDATE CMRTIME T6ETRID T6ERESP T6ECPUR T6ETMID T6EOPID
DETAIL
REPORT
END
SELECT TYPE 6E RECORDS FROM CMRDETL
USING CMRDATE CMRTIME T6ETRID T6ERESP T6ECPUR T6ETMID T6EOPID
DETAIL
REPORT
END
Detail report
REPORT1 DETAIL TRANSACTION ROSTER VERS: REL3.5.0
TIME: 06:27:25
DATE: 09/17/1998
PAGE: 1
RECORDED RECORDED TRAN RESPONSE CPU REAL TERM OPR
DATE TIME NAME TOTAL TIME TIME ID. ID.
---------- -------- --------------- ----------- ------------ ---- ---
09/17/1998 10:21:12 ETI0 3.511 0.067
09/17/1998 10:31:12 ETI0 0.186 0.021
ETI0 2 3.697 0.088
AVG ***** 1.848 0.044
09/17/1998 10:21:23 ETMO 5.633 0.321 L06B R01
09/17/1998 10:22:31 ETMO 0.906 0.078 L06B R01
ETMO 2 6.539 0.399
AVG ***** 3.269 0.199
09/17/1998 10:21:33 ETM2 5.504 0.174 L06B R01
09/17/1998 10:22:14 ETM2 1.353 0.155 L06B R01
09/17/1998 10:22:26 ETM2 1.099 0.138 L06B R01
ETM2 3 7.956 0.467
AVG ***** 2.652 0.156
TIME: 06:27:25
DATE: 09/17/1998
PAGE: 1
RECORDED RECORDED TRAN RESPONSE CPU REAL TERM OPR
DATE TIME NAME TOTAL TIME TIME ID. ID.
---------- -------- --------------- ----------- ------------ ---- ---
09/17/1998 10:21:12 ETI0 3.511 0.067
09/17/1998 10:31:12 ETI0 0.186 0.021
ETI0 2 3.697 0.088
AVG ***** 1.848 0.044
09/17/1998 10:21:23 ETMO 5.633 0.321 L06B R01
09/17/1998 10:22:31 ETMO 0.906 0.078 L06B R01
ETMO 2 6.539 0.399
AVG ***** 3.269 0.199
09/17/1998 10:21:33 ETM2 5.504 0.174 L06B R01
09/17/1998 10:22:14 ETM2 1.353 0.155 L06B R01
09/17/1998 10:22:26 ETM2 1.099 0.138 L06B R01
ETM2 3 7.956 0.467
AVG ***** 2.652 0.156
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*