FIFLAGS parameter - Revision history

JDamon: /* Summary */

2016-04-22T22:16:54Z

Summary

← Older revision		Revision as of 22:16, 22 April 2016
Line 4:		Line 4:
	<dt>Default value		<dt>Default value
	<dd>X'41' at file creation (But X'40' bit is turned off as soon as records are added to Table B.)		<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

JDamon: One small change to X'01' bit.

2016-04-22T22:09:06Z

One small change to X'01' bit.

← Older revision		Revision as of 22:09, 22 April 2016
Line 40:		Line 40:
	<tr><th><var>X'02'</var></th>		<tr><th><var>X'02'</var></th>
	<td>Current hash index list page full. Always on.</td></tr>		<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. </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]]

JAL: minor wordsmithing

2016-04-22T19:40:49Z

minor wordsmithing

← Older revision		Revision as of 19:40, 22 April 2016
Line 3:		Line 3:
	<dl>		<dl>
	<dt>Default value		<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		<dt>Parameter type
	<dd>File		<dd>File
Line 26:		Line 26:

	<tr><th><var> X'40'</var></th>		<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>		<tr><th><var> X'10'</var></th>

JDamon: Further clarification of flags

2016-04-22T17:35:05Z

Further clarification of flags

← Older revision		Revision as of 17:35, 22 April 2016
Line 3:		Line 3:
	<dl>		<dl>
	<dt>Default value		<dt>Default value
	<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~~.		<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

JAL: minor formatting

2016-04-22T17:04:36Z

minor formatting

← Older revision		Revision as of 17:04, 22 April 2016
Line 3:		Line 3:
	<dl>		<dl>
	<dt>Default value		<dt>Default value
	<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.		<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 13:		Line 13:
	<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). Turned off if not a sorted file. Only turned on when sorted file is populated.</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><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. Always on if true.</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 ~~<var>~~[[~~Table_C_~~(File_architecture)\|Table C]]~~</var>~~ logic for initial property entry. Always on if file is post-Release 9.0.</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><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>

			<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>		</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><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. </td></tr>
	</table>		</table>

	[[Category:File parameters]]		[[Category:File parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

JDamon: More clarifications on bit settings.

2016-04-22T02:25:46Z

More clarifications on bit settings.

← Older revision		Revision as of 02:25, 22 April 2016
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). Turned off if not a sorted file.</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. Only turned on when sorted file is populated.</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'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. Always on if true.</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. Always on if file is post-Release 9.0.</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'04'</var></th><td>Ordered Index list page full. Turned off when Table D is populated.
	</td></tr>		</td></tr>

JDamon: Added clarification of FIFLAGS bits.

2016-04-22T00:03:48Z

Added clarification of FIFLAGS bits.

← Older revision		Revision as of 00:03, 22 April 2016
Line 3:		Line 3:
	<dl>		<dl>
	<dt>Default value		<dt>Default value
	<dd>~~None~~		<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]]

DCameron: /* Description */

2014-10-23T10:46:13Z

Description

← Older revision		Revision as of 10:46, 23 October 2014
Line 21:		Line 21:
	<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.</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 Table C 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.</td></tr>
	<tr><th align="right"><var>X'02'</var></th><td>Current hash index list page full.</td></tr>		<tr><th align="right"><var>X'02'</var></th><td>Current hash index list page full.</td></tr>

DCameron: /* Description */

2014-10-23T10:45:05Z

Description

← Older revision		Revision as of 10:45, 23 October 2014
Line 20:		Line 20:
	<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).</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.</td></tr>
	<tr><th align="right"><var> X'10'</var></th><td>Field-level constraints. At least one field with a constraint (UNIQUE or AT-MOST-ONE) 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 Table C logic for initial property entry.</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 align="right"><var>X'04'</var></th><td>Ordered Index list page full.</td></tr>

DCameron: /* Description */

2014-10-23T09:11:44Z

Description

← Older revision		Revision as of 09:11, 23 October 2014
Line 19:		Line 19:
	<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).</td></tr>
	<tr><th align="right"><var> X'40'</var></th><td>Table B 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.</td></tr>
	<tr><th align="right"><var> X'10'</var></th><td>Field-level constraints. At least one field with a constraint (UNIQUE or AT-MOST-ONE) 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 (UNIQUE or AT-MOST-ONE) exists in the file.</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'08'</var></th><td>New Table C logic for initial property entry.</td></tr>