VMS Help ACCOUNTING, /SORT  *Conan The Librarian (sorry for the slow response - running on an old VAX)

    Sorts the selected records.

    Format

      /SORT[=([-]sort_field[,...])]

1 - Keyword

 sort_field[,...]

    Specifies the sort key.

    The following table shows the keywords available. You can specify
    up to ten sort fields.

    Keyword          Sorts on This Field

    ACCOUNT          Account
    ADDRESS          Address of the node that made the DECnet for
                     OpenVMS request
    BUFFERED_IO      Number of buffered I/Os
    DIRECT_IO        Number of direct I/Os
    ELAPSED          Elapsed time
    ENTRY            Print or batch job queue entry number
    EXECUTION        Number of images run by the process
    FAULTS           Number of hard and soft page faults
    FINISHED         Time record was logged in the accounting file
    GETS             Number of GETs from the file that was printed
    IDENT            Process identifier (PID)
    IMAGE            Image name (sorts only on file name portion of
                     the image file specification)
    JOB              Name of print or batch job
    NODE             Name of the node that made the DECnet for
                     OpenVMS request
    OWNER            PID of parent process
    PAGE_FILE        Peak page file usage
    PAGE_READS       Number of hard page faults
    PAGES            Number of pages printed
    PRIORITY         Base process priority, or print or batch queue
                     priority
    PROCESS          Type of process
    PROCESSOR        Total CPU time used
    QIOS             Number of QIOs to the printer
    QUEUE            Name of print or batch queue
    QUEUED           Time print job was queued
    STARTED          Start time
    STATUS           Final exit status code
    TERMINAL         Terminal name
    TYPE             Type of record
    UIC              User identification code
    USER             User name at local node
    VECTOR_          Vector CPU time (see the description of the
    PROCESSOR        /FULL qualifier for further details)
    VOLUMES          Number of volumes mounted
    WORKING_SET      Peak working set size

    For each keyword, see the description of the corresponding
    Accounting utility qualifier or the table in the /TYPE qualifier
    section for details of the types of record in which the
    corresponding field is present.

2 - Description

    The /SORT qualifier merges the selected records from each
    input file (each file listed in the parameter to the ACCOUNTING
    command) and sorts them using the specified sort key. The records
    are sorted according to the value of the first sort field in the
    list, and when two or more records have the same value in this
    field, they are sorted by the value of the second sort field in
    the list, and so on.

    The records are sorted in ascending order of the sort field
    value. If the keyword is preceded by a minus sign, the records
    are sorted in descending order.

    When you use the /SORT qualifier, records are rejected if they do
    not contain the sort field. For example, /SORT=IMAGE rejects all
    records that are not of type IMAGE, because the image name field
    is only present in records of type IMAGE. Similarly, /SORT=PAGES
    rejects all records except those for print jobs.

    You cannot use the /SORT qualifier with the /SUMMARY qualifier.

3 - Examples

    1.$ ACCOUNTING /TYPE=PRINT /SORT=USER

      This example processes the file SYS$MANAGER:ACCOUNTNG.DAT. It
      produces a brief report of all the records for print jobs and
      displays them in user name order.

      The following example shows the report that is produced:

        Date / Time           Type  Subtype Username     ID      Source  Status
        -------------------------------------------------------------------------
        14-JAN-2000 09:53:05  PRINT         BROWN        20A00193        00040001
        13-JAN-2000 13:36:04  PRINT         BROWN        20A00442        00000001
        13-JAN-2000 12:42:37  PRINT         BROWN        20A00442        00000001
        13-JAN-2000 14:43:56  PRINT         DECNET_MAIL  20A00456        00000001
        14-JAN-2000 19:39:01  PRINT         DECNET_MAIL  20A00265        00000001
        14-JAN-2000 20:09:03  PRINT         DECNET_MAIL  20A00127        00000001
        14-JAN-2000 20:34:45  PRINT         DECNET_MAIL  20A00127        00000001
        14-JAN-2000 11:23:34  PRINT         FISH         20A0032E        00040001
        14-JAN-2000 16:43:16  PRINT         JONES        20A00070        00040001
        14-JAN-2000 09:30:21  PRINT         SMITH        20A00530        00040001

    2.$ ACCOUNTING MYFILE1.DAT,MYFILE2.DAT /SORT=IMAGE -
      _$ /FULL /REJECTED=NON_IMAGE.DAT

      This example processes two files, MYFILE1.DAT and MYFILE2.DAT,
      to produce a full report of records of type IMAGE, sorted in
      image name order. It creates the file NON_IMAGE.DAT, and copies
      all records except those of type IMAGE to that file. Notice
      that no selection qualifiers are used, and so all records are
      selected for processing. When the records are sorted, records
      that do not contain an image name are rejected.