FastSort Manual

Index
FastSort Manual—429834-003
Index-11
S
SORTMERGESTART procedure
automatic configuration 6-5
configuring subsort processes 6-6
data slack 5-28
defining key fields 5-20
example 5-35
flags parameter 4-9, 5-31
index slack 5-28
initial scratch file 5-25
input file access 5-21
output file access 5-23
output file type 5-24
output record format 5-22
parallel sorting 6-3, 6-11
priority word in process-start
parameter 6-10, 6-13
process-start parameter 6-9
returning records to an application
process 4-6
scratch-block parameter 6-11
segment word in process-start
parameter 6-12
sending records from application
process 4-5
sort-program word in process-start
parameter 6-10, 6-12
swap-file word in process-start
parameter 6-9
, 6-12
syntax 5-19
user error procedure 5-36
SORTMERGESTATISTICS procedure
description of 4-3
example 5-39
parallel sorting 6-3
statistics structure 5-38
syntax 5-37
SORTPROG process
as a distributor-collector process 6-1
as a subsort process 6-1
communicating with 5-1
SORTPROG process (continued)
copying for subsort processes 6-10
copying for the distributor-
collector 6-12
description 1-8
parallel load operations 8-7
starting with procedures 4-2, 5-19
stopping 4-2
stopping with
SORTMERGEFINISH 5-12
used by SQL/MP 1-10, 8-1
SORT_DEFAULTS DEFINE
See =_SORT_DEFAULTS DEFINE
SQL/MP
COMMENT keyword 8-10
configuration file for parallel index
loading 8-10
configuring a CREATE INDEX
statement 8-8
criteria for in-memory sorts 8-1
DEFINEs 7-1
DISTINCT clause 8-4
GROUP BY clause 8-4
index 1-10, 8-8
LOAD command 8-15
nesting command files from
SQLCI 9-16
operations that invoke FastSort 8-1
optimizing clause combinations 8-5
sample file 8-10, 8-14
sort merge joins 8-6
UNION clause 8-5
=_SORT_DEFAULTS DEFINE 8-2
Stack space, required by system
procedures 5-2
, 5-29
Starting a sort or merge
procedures 4-2
RUN command 3-19