FIFLAGS parameter: Difference between revisions
Jump to navigation
Jump to search
(Added clarification of FIFLAGS bits.) |
|||
| Line 3: | Line 3: | ||
<dl> | <dl> | ||
<dt>Default value | <dt>Default value | ||
<dd> | <dd>X'41' - (Appends page full) File status switches. These flags change as soon as records are added to Table B or the ordered index is populated. | ||
<dt>Parameter type | <dt>Parameter type | ||
<dd>File | <dd>File | ||
| Line 18: | Line 18: | ||
<table> | <table> | ||
<tr><th>Setting</th><th>Meaning</th></tr> | <tr><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'80'</var></th><td>Group index entry required (sorted files). Turned off if not a sorted file.</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 align="right"><var> X'40'</var></th><td><var>[[Table_B_(File_architecture)|Table B]]</var> appends page full. Turned off when a record is stored in Table B</td></tr> | ||
<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> | <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> | ||
<tr><th align="right"><var>X'08'</var></th><td>New <var>[[Table_C_(File_architecture)|Table C]]</var> logic for initial property entry.</td></tr> | <tr><th align="right"><var>X'08'</var></th><td>New <var>[[Table_C_(File_architecture)|Table C]]</var> 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 align="right"><var>X'04'</var></th><td>Ordered Index list page full. Turned off when Table D is populated. | ||
<tr><th align="right"><var>X'02'</var></th><td>Current hash index list page full.</td></tr> | </td></tr> | ||
<tr><th align="right"><var>X'02'</var></th><td>Current hash index list page full. Always on.</td></tr> | |||
<tr><th align="right"><var>X'01'</var></th><td>File is post-Release 3.16. </td></tr> | <tr><th align="right"><var>X'01'</var></th><td>File is post-Release 3.16. </td></tr> | ||
</table> | </table> | ||
[[Category:File parameters]] | [[Category:File parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 00:03, 22 April 2016
File status flags
Summary
- Default value
- X'41' - (Appends page full) File status switches. These flags change as soon as records are added to Table B or the ordered index is populated.
- 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):
| Setting | Meaning |
|---|---|
| X'80' | Group index entry required (sorted files). Turned off if not a sorted file. |
| X'40' | Table B appends page full. Turned off when a record is stored in Table B |
| X'10' | Field-level constraints. At least one field with a constraint (UNIQUE or AT-MOST-ONE) exists in the file. |
| X'08' | New Table C logic for initial property entry. |
| 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. |