FIFLAGS parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
 
(7 intermediate revisions by 3 users not shown)
Line 3: Line 3:
<dl>
<dl>
<dt>Default value
<dt>Default value
<dd>None
<dd>X'41' at file creation (But X'40' bit is turned off as soon as records are added to Table B.)
<dd>X'4F' after initialization
<dt>Parameter type
<dt>Parameter type
<dd>File
<dd>File
Line 13: Line 14:
<dd><var class="product">Model 204 V6.1</var> or earlier
<dd><var class="product">Model 204 V6.1</var> or earlier
</dl>
</dl>
==Description==
==Description==
<p>The file status</p>
<p>
<p>Valid settings of FIFLAGS are (options can be summed):</p>
The file status</p>
<p>
Valid settings of <var>FIFLAGS</var> are (options can be summed):</p>
<table>
<table>
<tr><th>Setting</th><th>Meaning</th></tr>
<tr class="head"><th>Setting</th><th>Meaning</th></tr>
<tr><th align="right"><var> X'80'</var></th><td>Group index entry required (sorted files).</td></tr>
 
<tr><th align="right"><var> X'40'</var></th><td><var>[[Table_B_(File_architecture)|Table B]]</var> appends page full.</td></tr>
<tr><th><var> X'80'</var></th>
<tr><th align="right"><var> X'10'</var></th><td>Field-level constraints. At least one field with a constraint (<var>[[Field_attributes#UNIQUE_attribute|UNIQUE]]</var> or <var>[[Field_attributes#AT-MOST-ONE_and_REPEATABLE_attributes|AT-MOST-ONE]]</var>) exists in the file.</td></tr>
<td>Group index entry required (sorted files).  Turned off if not a sorted file. Only turned on when sorted file is populated.</td></tr>
<tr><th align="right"><var>X'08'</var></th><td>New Table C logic for initial property entry.</td></tr>
 
<tr><th align="right"><var>X'04'</var></th><td>Ordered Index list page full.</td></tr>
<tr><th><var> X'40'</var></th>
<tr><th align="right"><var>X'02'</var></th><td>Current hash index list page full.</td></tr>
<td>[[Table B (File_architecture)|Table B]] appends page full. Turned on when file is initially created (see "Default value" above), then turned off when a record is stored in Table B. Turned back on if Table B fills up. </td></tr>
<tr><th align="right"><var>X'01'</var></th><td>File is post-Release 3.16. </td></tr>
 
<tr><th><var> X'10'</var></th>
<td>Field-level constraints. At least one field with a constraint (<var>[[Field_attributes#UNIQUE_attribute|UNIQUE]]</var> or <var>[[Field_attributes#AT-MOST-ONE_and_REPEATABLE_attributes|AT-MOST-ONE]]</var>) exists in the file. Always on if true.</td></tr>
 
<tr><th><var>X'08'</var></th>
<td>New [[Table C (File_architecture)|Table C]] logic for initial property entry. Always on if file is post-Release 9.0.</td></tr>
 
<tr><th><var>X'04'</var></th>
<td>Ordered Index list page full. Turned off when Table D is populated.
</td></tr>
 
<tr><th><var>X'02'</var></th>
<td>Current hash index list page full. Always on.</td></tr>
<tr><th><var>X'01'</var></th><td>File is post-Release 3.16. Probably always on.</td></tr>
</table>
</table>
[[Category:File parameters]]
[[Category:File parameters]]
[[Category:Parameters]]
[[Category:Parameters]]

Latest revision as of 22:16, 22 April 2016

File status flags

Summary

Default value
X'41' at file creation (But X'40' bit is turned off as soon as records are added to Table B.)
X'4F' after initialization
Parameter type
File
Where set
View-only
Related products
All
Introduced
Model 204 V6.1 or earlier

Description

The file status

Valid settings of FIFLAGS are (options can be summed):

SettingMeaning
X'80' Group index entry required (sorted files). Turned off if not a sorted file. Only turned on when sorted file is populated.
X'40' Table B appends page full. Turned on when file is initially created (see "Default value" above), then turned off when a record is stored in Table B. Turned back on if Table B fills up.
X'10' Field-level constraints. At least one field with a constraint (UNIQUE or AT-MOST-ONE) exists in the file. Always on if true.
X'08' New Table C logic for initial property entry. Always on if file is post-Release 9.0.
X'04' Ordered Index list page full. Turned off when Table D is populated.
X'02' Current hash index list page full. Always on.
X'01'File is post-Release 3.16. Probably always on.