FastSort Manual

Introduction to FastSort
FastSort Manual—429834-003
1-10
Class SORT and SUBSORT DEFINEs
Class SORT and SUBSORT DEFINEs
You can use class SORT or SUBSORT DEFINEs to configure a sort or subsort. You
specify the DEFINE(s) before running a SORTPROG process, and the information is
applied to the sort process when it is run. You can use class SORT or SUBSORT
DEFINEs to specify information such as the disk volume for the scratch file, the
processors to use, and so on.
For example, you can use class SORT or SUBSORT DEFINEs to specify a scratch
volume. In the following example, the SUBSORT DEFINE named =SUBSORTA
specifies the $DISK02 disk as the initial scratch volume and the $SPOOL disk for the
swap file:
SET DEFINE CLASS SUBSORT
SET DEFINE SCRATCH $disk02
SET DEFINE SWAP $spool
...
ADD DEFINE =subsorta
...
DEFINE information is valid until modified, deleted, or disabled. For more information
about using SORT and SUBSORT DEFINEs with FastSort, See Section 7, Using
SORT and SUBSORT DEFINEs.
Products That Use FastSort
These HP products use FastSort to perform sort or merge operations:
If SQL/MP is installed on your system, SQL uses FastSort to sort table rows in certain
queries. If you issue a SELECT statement with the DISTINCT, ORDER BY, or GROUP
BY clause, SQL starts a SORTPROG process to sort the rows.
Product FastSort Function
COBOL85 Executes a SORT or MERGE statement
CROSSREF Program Sorts a cross-reference listing
Enform Database Manager Sorts records for a report
File Utility Program (FUP) Loads data into a file
SQL/MP Sorts entries in a query and load data
into a table or an index table
Peripheral Utility Program (PUP) Sorts entries in the free-space table
HP NonStop Transaction Management Facility
(TMF)
Manages audit trail information