SPILLADD parameter: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
<dd>All | <dd>All | ||
<dt>Introduced | <dt>Introduced | ||
<dd><var class="product">Model 204 | <dd><var class="product">Model 204 V2.1</var> or earlier | ||
</dl> | </dl> | ||
==Description== | ==Description== | ||
<p>The number of times records have spilled (sorted and hash key files)</p> | <p>The number of times records have spilled ([[Sorted_files|sorted]] and [[Hash_key_files|hash key]] files)</p> | ||
<p>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.</p> | <p>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.</p> | ||
[[Category:File parameters]] | [[Category:File parameters]] | ||
[[Category:Tables parameters]] | [[Category:Tables parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Latest revision as of 14:46, 6 September 2017
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.