FastSort Manual

Contents
FastSort Manual—429834-003
iv
7. Using SORT and SUBSORT DEFINEs
Understanding Statistics From Parallel Sorting 6-14
Identifying the Causes of Errors 6-14
Parallel Sorting From C Programs 6-15
Parallel Sorting From COBOL85 Programs 6-19
Parallel Sorting From TAL Programs 6-22
7. Using SORT and SUBSORT DEFINEs
Determining the Precedence of DEFINEs 7-1
Setting DEFINE Attributes 7-2
Setting SORT DEFINE Attributes 7-2
Setting SUBSORT DEFINE Attributes 7-5
Creating and Using DEFINEs Interactively 7-7
Enabling DEFINEs 7-7
Creating a SORT DEFINE 7-7
Displaying a DEFINE 7-8
Creating a SUBSORT DEFINE 7-9
Modifying a DEFINE 7-9
Deleting a DEFINE 7-10
Using DEFINEs With Interactive FastSort 7-10
Creating and Using DEFINEs Programmatically 7-10
Creating and Modifying DEFINEs Programmatically 7-11
Using DEFINEs With Programmatic FastSort 7-12
Creating and Using the =_SORT_DEFAULTS DEFINE 7-13
Examples of SORTand SUBSORT DEFINEs 7-15
Serial Sort Run Example 7-15
Parallel Sort Run Example
7-17
8. Sorting From NonStop SQL/MP
How SQL/MP Implements a Sort 8-1
Configuring Your SQL/MP Sort Environment
8-2
Setting Up a =_SORT_DEFAULTS DEFINE 8-2
Ordering and Grouping Query Results
8-4
Optimizing SQL Clause Combinations
8-5
Using a Sort Merge Join 8-6
Loading Data
8-7
Configuring a CREATE INDEX Statement
8-8
Configuring a LOAD Statement
8-15
9. Optimizing Sort Performance
Managing Sort Workspace 9-1