SPILLADD parameter

From m204wiki
Revision as of 14:46, 6 September 2017 by DCameron (talk | contribs) (→‎Description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Spill indicator - adds

Summary

Default value
None
Parameter type
Tables
Where set
View-only
Related products
All
Introduced
Model 204 V2.1 or earlier

Description

The number of times records have spilled (sorted and hash key files)

When a record is added to a nonpreferred overflow area in a sorted file, SPILLADD is incremented by the number of overflow areas that have to be skipped before the record can be added. For a hash key file, SPILLADD is incremented by the number of extra pages that are tried before a record is added.

Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=SPILLADD_parameter&oldid=104191"