2 Sort Statements and Functions
Introduction
This chapter describes the syntax needed to use SORT software. The statements and functions provided with SORT are:
- WORKFILE IS #
- A statement specifying the hierarchical structure (thread) of the data sets to be sorted, the work space for sorting, and the workfile itself.
- SORT BY
- A statement specifying the order in which data is to be sorted.
- FIND
- A statement used to select a subset of record pointers from the data base or the current workfile.
- QFIND
- A statement used to select a subset of record pointers from the data base.
- WFLEN
- A function returning the number of logical records in the workfile.
Two IMAGE statements, DBASE IS and IN DATA SET, are used to define the data base and data sets before unpacking data entries with SORT.
In addition, many Eloquence file storage operations (PRINT #, READ #, REC, etc.) are used in conjunction with SORT workfiles. Because of the workfile structure, these operations may work differently with SORT than as described in the Eloquence Manual. These differences are covered near the end of the chapter.
Eloquence Sort Manual - 19 DEC 2002