FIFLAGS parameter: Difference between revisions
Jump to navigation
Jump to search
m (minor formatting) |
(Further clarification of flags) |
||
Line 3: | Line 3: | ||
<dl> | <dl> | ||
<dt>Default value | <dt>Default value | ||
<dd>X'41' - | <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. | ||
<dt>Parameter type | <dt>Parameter type | ||
<dd>File | <dd>File |
Revision as of 17:35, 22 April 2016
File status flags
Summary
- Default value
- 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.
- 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. Only turned on when sorted file is populated. |
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. 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. |