Skip to Content

DETAIL (tabulate and summarize each record)

DETAIL requests a tabular summary at each control break based on value of the variables specified in ORDER BY and USING statement changes.

A count is maintained for each item that has common value matching variables specified in ORDER BY statement. A control-break is the point in a report where the value of the variables (specified in ORDER BY and USING statements) changes. For this reason, we recommend that you always make the first USING variable the same as the ORDER BY variable if one variable is in use.  For multiple variables in ORDER BY, the same variables must be listed, in the same order, as the first variables in the USING statement. 

Related topic

PRL-control-statement-verbs

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:

 DETAIL PRL statement using 1 ORDER BY field
    SET CLASS = 'R'
    SET WIDTH = 255
    SET TITLE = 'DETAIL REPORT USING 1 ORDER BY FIELDS'
    SET ZHEADING  = 'SINGLE'
    SELECT TYPE 6E RECORDS FROM CMRDETLN
    USING T6ETRID CMR$SYS T6EUSER T6ERESP T6ECPUR
    ORDER BY T6ETRID
    DETAIL
    REPORT
    END                  


Detail report using 1 ORDER BY field
REPORT01                              DETAIL REPORT USING 1 ORDER BY FIELDS   VERS:     7.3.00
                                                                              TIME:   03:47:32
                                                                             DATE: 08/01/2023
                                                                                            PAGE:          1

TRAN             SYSTEM    EXTENDED       RESPONSE       CPU REAL
NAME      TOTAL  APPLID    USER-ID.           TIME           TIME
---------------  --------  --------  -------------  -------------

ASL1             BCVDN740  MVSAMS1        0.006564       0.000805
ASL1             BCVDN740  MVSAMS1        0.000147       0.000029
ASL1             BCVDN740  MVSAMS1        0.000411       0.000140
ASL1             BCVDN740  MVSAMS1        0.001038       0.000178
ASL1             BCVDN740  MVSAMS1        0.000730       0.000306
ASL1             BCVDN740  MVSAMS1        0.000121       0.000021
ASL1             BCVDN740  MVSAMS1        0.001259       0.000178
ASL1             BCVDN740  MVSAMS1        0.000445       0.000034
ASL1             BCVDN740  MVSAMS1        0.000452       0.000181
ASL1             BCVDN740  MVSAMS1        0.000104       0.000023
ASL1         10                           0.011271       0.001895
     AVG *****                           0.001127       0.000189

ASL4             BCVDN740  MVSAMS1        0.017399       0.000361
ASL4             BCVDN740  MVSAMS1        0.001297       0.000232
ASL4             BCVDN740  MVSAMS1        0.001046       0.000076
ASL4             BCVDN740  MVSAMS1        0.001559       0.000213
ASL4             BCVDN740  MVSAMS1        0.000780       0.000072
ASL4          5                           0.022081       0.000954
     AVG *****                           0.004416       0.000191

ASPL             BCVDN740  MVSAMS1        8.627133       0.001419
ASPL             BCVDN740  MVSAMS1        1.512864       0.000456
ASPL             BCVDN740  MVSAMS1        1.380369       0.000381
ASPL             BCVDN740  MVSAMS1        0.884634       0.000450
ASPL             BCVDN740  MVSAMS1        1.207627       0.000449
ASPL          5                          13.612627       0.003155
     AVG *****                           2.722525       0.000631

PTQR             BCVDH740  MVSNYS1       28.882869       0.002303
PTQR          1                          28.882869       0.002303
     AVG *****                          28.882869       0.002303

PTS1             BCVDH740  MVSNYS1        0.124665       0.004982
PTS1             BCVDH740  MVSNYS1        0.000502       0.000298
PTS1             BCVDH740  MVSNYS1      150.647502       0.002093
PTS1             BCVDH740  MVSNYS1      150.566089       0.002282
PTS1          4                         301.338758       0.009655
     AVG *****                          75.334689       0.002414

TSTL             BCVDN740  MVSAMS1        0.004067       0.001169
TSTL             BCVDN740  MVSAMS1        0.021692       0.000345
TSTL          2                           0.025759       0.001514
     AVG *****                           0.012879       0.000757

TST1             BCVDN740  MVSAMS1        0.012054       0.001194
TST1          1                           0.012054       0.001194
     AVG *****                           0.012054       0.001194                 
DETAIL PRL statement using 2 ORDER BY fields
    SET CLASS = 'R'                                
    SET WIDTH = 255                                
    SET TITLE = 'DETAIL REPORT USING 2 ORDER BY FIELDS'    
    SET ZHEADING  = 'SINGLE'                       
    SELECT TYPE 6E RECORDS FROM CMRDETLN
       USING T6EUSER T6ETRID T6ERESP T6ECPUR
    ORDER BY T6EUSER T6ETRID
    DETAIL
    REPORT
END
Detail report using 2 ORDER BY fields
REPORT02                    DETAIL REPORT USING 2 ORDER BY FIELDS       VERS:     7.3.00
                                                                        TIME:   03:47:32
                                                                        DATE: 08/01/2023                                                                            
                                                                        PAGE:          1
                                                       
EXTENDED  TRAN                  RESPONSE       CPU REAL
USER-ID.  NAME      TOTAL           TIME           TIME
--------  ---------------  -------------  -------------
                                                       
BCVCSTC   CLS2                  0.007834       0.001249
                                                       
BCVCSTC   CLS2                  0.000850       0.000117
                                                       
          CLS2          2       0.008684       0.001366
                AVG *****       0.004342       0.000683
                                                       
BCVCSTC   COI0                  5.390376       0.001459
                                                       
          COI0          1       5.390376       0.001459
                AVG *****       5.390376       0.001459
                                                       
BCVCSTC   FCD2                  0.000476       0.000432
                                                       
BCVCSTC   FCD2                  0.000702       0.000484
                                                       
          FCD2          2       0.001178       0.000916
                AVG *****       0.000589       0.000458
                                                       
BCVCSTC   *             5       5.400238       0.003741
                AVG *****       1.080048       0.000748
                                                       
MVSAMS1   FCD2                  0.007979       0.004423
                                                       
MVSAMS1   FCD2                  0.012490       0.005916
                                                       
MVSAMS1   FCD2                  0.008960       0.004463
                                                       
MVSAMS1   FCD2                  0.007763       0.004359
                                                       
MVSAMS1   FCD2                  0.009389       0.005439
                                                       
MVSAMS1   FCD2                  0.006304       0.003976
                                                       
MVSAMS1   FCD2                  0.016552       0.004345
                                                       
MVSAMS1   FCD2                  0.019286       0.004175
                                                       
MVSAMS1   FCD2                  0.010302       0.004909
                                                       
          FCD2          9       0.099025       0.042005
                AVG *****       0.011003       0.004667
                                                       
MVSAMS1   *             9       0.099025       0.042005
                               AVG *****       0.011003       0.004667


DETAIL PRL statement using 3 ORDER BY fields
    SET CLASS = 'R'
    SET WIDTH = 255
    SET TITLE = 'DETAIL REPORT USING 3 ORDER BY FIELDS'
    SET ZHEADING  = 'SINGLE'
    SELECT TYPE 6E RECORDS FROM CMRDETLN
       USING CMR$SYS T6EUSER T6ETRID T6ERESP T6ECPUR
    ORDER BY CMR$SYS T6EUSER T6ETRID
    DETAIL
    REPORT
    END          
Detail report using 3 ORDER BY fields
REPORT03                        DETAIL REPORT USING 3 ORDER BY FIELDS        VERS:     7.3.00
                                                                             TIME:   03:47:32
                                                                             DATE: 08/01/2023
                                                                             PAGE:          1                                                                                                                                          
                                                                                                                                         
                                                                                                                                         
                                                                                                                                         
SYSTEM    EXTENDED  TRAN                  RESPONSE       CPU REAL                                                                         
APPLID    USER-ID.  NAME      TOTAL           TIME           TIME                                                                         
--------  --------  ---------------  -------------  -------------                                                                         
                                                                                                                                         
BCVDH740  BCVCSTC   CLS2                  0.007834       0.001249                                                                         
                                                                                                                                         
BCVDH740  BCVCSTC   CLS2                  0.000850       0.000117                                                                         
                                                                                                                                         
                    CLS2          2       0.008684       0.001366                                                                         
                          AVG *****       0.004342       0.000683                                                                         
                                                                                                                                         
BCVDH740  BCVCSTC   COI0                  5.390376       0.001459                                                                         
                                                                                                                                         
                    COI0          1       5.390376       0.001459                                                                         
                          AVG *****       5.390376       0.001459                                                                         
                                                                                                                                         
BCVDH740  BCVCSTC   FCD2                  0.000476       0.000432                                                                         
                                                                                                                                         
BCVDH740  BCVCSTC   FCD2                  0.000702       0.000484                                                                         
                                                                                                                                         
                    FCD2          2       0.001178       0.000916                                                                         
                          AVG *****       0.000589       0.000458                                                                         
                                                                                                                                         
BCVDH740  BCVCSTC   *             5       5.400238       0.003741                                                                         
                          AVG *****       1.080048       0.000748                                                                         
                                                                                                                                         
BCVDH740  MVSNYS1   CLS2                  0.001778       0.000325                                                                         
                                                                                                                                         
BCVDH740  MVSNYS1   CLS2                  0.000293       0.000131                                                                         
                                                                                                                                         
BCVDH740  MVSNYS1   CLS2                  0.001131       0.000242                                                                         
                                                                                                                                         
BCVDH740  MVSNYS1   CLS2                  0.000193       0.000057                                                                         
                                                                                                                                         
                    CLS2          4       0.003395       0.000755                                                                         
                          AVG *****       0.000849       0.000189                                                                         
                                                                                                                                         
BCVDH740  MVSNYS1   *             4       0.003395       0.000755                                                                         
                          AVG *****       0.000849       0.000189                                                                         
                                                                                                                                         
BCVDH740  *         *             9       5.403633       0.004496                                                                         
                                         AVG *****       0.600404       0.000500                                                                         

DETAIL PRL statement using 4 ORDER BY fields
    SET CLASS = 'R'                                
    SET WIDTH = 255                                
    SET TITLE = 'DETAIL REPORT USING 4 ORDER BY  FIELDS'    
    SET ZHEADING  = 'SINGLE'                       
    SELECT TYPE 6E RECORDS FROM CMRDETLN
       USING T6ESMFID CMR$SYS T6EUSER T6ETRID T6ERESP T6ECPUR
    ORDER BY T6ESMFID CMR$SYS T6EUSER T6ETRID
    DETAIL
    REPORT
    END             


Detail report using 4 ORDER BY fields
REPORT04                         DETAIL REPORT USING 4 ORDER BY FIELDS        VERS:     7.3.00
                                                                              TIME:   03:47:32
                                                                              DATE: 08/01/2023
                                                                              PAGE:          1                                                                                                                                          
                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
                                                                                                                                         
SMF   SYSTEM    EXTENDED  TRAN                  RESPONSE       CPU REAL                                                                   
ID    APPLID    USER-ID.  NAME      TOTAL           TIME           TIME                                                                   
----  --------  --------  ---------------  -------------  -------------                                                                   
                                                                                                                                         
SJSC  BCVDH740  BCVCSTC   CLS2                  0.007834       0.001249                                                                   
                                                                                                                                         
SJSC  BCVDH740  BCVCSTC   CLS2                  0.000850       0.000117                                                                   
                                                                                                                                         
                          CLS2          2       0.008684       0.001366                                                                   
                                AVG *****       0.004342       0.000683                                                                   
                                                                                                                                         
SJSC  BCVDH740  BCVCSTC   COI0                  5.390376       0.001459                                                                   
                                                                                                                                         
                          COI0          1       5.390376       0.001459                                                                   
                                AVG *****       5.390376       0.001459                                                                   
                                                                                                                                         
SJSC  BCVDH740  BCVCSTC   FCD2                  0.000476       0.000432                                                                   
                                                                                                                                         
SJSC  BCVDH740  BCVCSTC   FCD2                  0.000702       0.000484                                                                   
                                                                                                                                         
                          FCD2          2       0.001178       0.000916                                                                   
                                AVG *****       0.000589       0.000458                                                                   
                                                                                                                                         
SJSC  BCVDH740  BCVCSTC   *             5       5.400238       0.003741                                                                   
                                AVG *****       1.080048       0.000748                                                                   
                                                                                                                                         
SJSC  BCVDH740  MVSNYS1   CLS2                  0.001778       0.000325                                                                   
                                                                                                                                         
SJSC  BCVDH740  MVSNYS1   CLS2                  0.000293       0.000131                                                                   
                                                                                                                                         
SJSC  BCVDH740  MVSNYS1   CLS2                  0.001131       0.000242                                                                   
                                                                                                                                         
SJSC  BCVDH740  MVSNYS1   CLS2                  0.000193       0.000057                                                                   
                                                                                                                                         
                          CLS2          4       0.003395       0.000755                                                                   
                                AVG *****       0.000849       0.000189                                                                   
                                                                                                                                         
SJSC  BCVDH740  MVSNYS1   *             4       0.003395       0.000755                                                                   
                                AVG *****       0.000849       0.000189                                                                   
                                                                                                                                         
SJSC  BCVDH740  *         *             9       5.403633       0.004496                                                                   
                                AVG *****       0.600404       0.000500  

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for CICS 7.4