FIFLAGS parameter: Difference between revisions

Revision as of 19:40, 22 April 2016

File status flags

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

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. 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.

@@ Line 3: / Line 3: @@
 <dl>
 <dt>Default value
-<dd>X'41' - After CREATE; Table B Appends-page full, file is post-Release 3.16.  The Appends-page-full flag will be turned off as soon as records are added to Table B.  it will be turned back on if Table B fills up.
+<dd>X'41' at file creation (But X'40' bit is turned off as soon as records are added to Table B.)
 <dt>Parameter type
 <dd>File
@@ Line 26: / Line 26: @@
 <tr><th><var> X'40'</var></th>
-<td>[[Table B (File_architecture)|Table B]] appends page full. Turned off when a record is stored in Table B.</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><var> X'10'</var></th>