Tabular Reports › How Report Sorting Works › SORT ASCENDING Operand-Sort in Ascending Order

SORT ASCENDING Operand-Sort in Ascending Order

To sort reports in ascending order, add the SORT ASCENDING operand to the TAB command.

Example: Sample Commands and Reports

• The following commands produce a report sorted so that the five terminals using the fewest transactions are listed in ascending order of transaction use:

  TAB TERMID(0A++) FOR 5 SORT ASCENDING,
      TRAN USE AND,
      TERM RESP AND,
      TERM I/OTIME
  END
  RUN
  

  A report like the following is generated:

    TERM     TRAN     TERM     TRAN
     ID       USE     RESP     TMIO
  -------- -------- -------- --------
  0A04          3    0.038    0.004
  0A18          6    0.103    0.002
  0A0F          6    0.172    34.89
  0A11         13    0.158    0.719
  0A08         23    0.082    1.970
  -------- -------- -------- --------
  SUMMARY      51    0.109    5.177
  -------- -------- -------- --------
  

• You can specify the SORT operand with a variable other than the first variable. For example, the following commands generate a report sorted by transaction use, the third variable specified:

  TAB TRANID TRAN TCPU AND,
             TRAN USE SORT ASCENDING
  END
  RUN
  

  A report like the following is generated:

     TRAN     TRAN     TRAN
     ID       CPU      USE
  -------- -------- --------
  RAPP      0.098        2
  PINV      1.486        2
  PADI      0.350        2
  SPAM      0.132        3
  RAPL      0.011        4
  CSSN      0.071        8
  CSGM      0.007        8
  CATD      0.105        9
  JJJ       0.221       10
  CSPQ      0.113       10
  VGBC      0.055       13
  POSS      0.035       37
  PSPI      0.097       43
  KCP       7.581       45
  TCP       0.572       46
  CSNE      0.010       49
  X25T      0.132       57
  -------- -------- --------
  SUMMARY   1.123      348 
  -------- -------- --------