SPILLADD parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Template:SPILLADD parameter subtitle}}
==Summary==
==Summary==
<dl>
<dl>
Line 10: Line 11:
<dd>All
<dd>All
<dt>Introduced
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
<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.