SORT-TABLE
Generates a formatted listing of the contents of a file based on the selection criteria entered in the same way as SORT, but tabulated in a similar way to an SQL SELECT statement, and without pagination.
Syntax
SORT-TABLE
Refer to Sentence Structure for descriptions of these parameters and the standard options.
Special options
S Displays a summary at the end of the listing.
Comments
As the width of the columns cannot be determined until all the data has been processed, large data sets will take longer to display.
Example
:SORT-TABLE ROOMS WITH ROOM-CODE "ST" BED-TYPE RATE GUEST-NAME LEAVE-DATE (S