Hash key files - Revision history

ELowell: /* Characteristics of hash key files */

2018-03-20T20:51:41Z

Characteristics of hash key files

← Older revision		Revision as of 20:51, 20 March 2018
Line 21:		Line 21:
	<li>Value of a record's hash key field cannot be changed in any way. You can, however, delete the entire record and store it again with a different hash key value.</li>		<li>Value of a record's hash key field cannot be changed in any way. You can, however, delete the entire record and store it again with a different hash key value.</li>

	<li>Special forms of the SOUL [[Data maintenance#STORE RECORD statement\|STORE RECORD statement]] and the Host Language <var>IFSTOR</var> and <var>IFBREC</var> functions allow a hash key to be specified for a new record. ~~See the <var class="book">[[Media:M204 HLIReference V75.pdf\|Rocket Model 204 Host Language Interface Reference Manual]]</var> for details.~~ </li>		<li>Special forms of the SOUL [[Data maintenance#STORE RECORD statement\|STORE RECORD statement]] and the Host Language <var>[[IFSTOR (HLI function)\|IFSTOR]]</var> and <var>[[IFBREC (HLI function)\|IFBREC]]</var> functions allow a hash key to be specified for a new record.</li>
	</ul>		</ul>

2016-09-06T17:03:38Z

Storing records in a hash key file: add link

← Older revision		Revision as of 17:03, 6 September 2016
Line 83:		Line 83:
	==Storing records in a hash key file==		==Storing records in a hash key file==
	<p>		<p>
	Special forms of the SOUL <var>[[Data maintenance#STORE RECORD statement\|STORE RECORD]]</var> statement and the Host Language <var>IFBREC</var> function allow a hash key to be specified for a new record. They are identical to the special forms used with sorted files. Refer to ~~the <var class="book">Rocket~~ Model 204 ~~Host Language Interface Reference Manual</var>~~ for ~~details~~. </p>		Special forms of the SOUL <var>[[Data maintenance#STORE RECORD statement\|STORE RECORD]]</var> statement and the Host Language <var>[[IFBREC (HLI function)\|IFBREC]]</var> function allow a hash key to be specified for a new record. They are identical to the special forms used with sorted files. Refer to [[HLI: Model 204 files and records#Data files\|Data files]] for a general description. </p>

	===File Load utility restrictions===		===File Load utility restrictions===

2016-09-06T16:47:55Z

Creating a hash key file: add link

← Older revision		Revision as of 16:47, 6 September 2016
Line 79:		Line 79:
	====Defining hash key fields====		====Defining hash key fields====
	<p>		<p>
	Unlike ordinary field names, the field name of the hash key is not defined with a <var>DEFINE</var> command. Specify the desired field description for the hash key in the <var>INITIALIZE</var> command. Hash key fields cannot have the <var>CODED</var>, <var>INVISIBLE</var>, <var>BINARY</var>, <var>FLOAT</var>, or <var>KEY</var> attributes, and they cannot have the <var>UPDATE</var> option specified for them. ~~The file initialization chapter~~ provides a full description of the <var>INITIALIZE</var> command and its use with hash key fields.</p>		Unlike ordinary field names, the field name of the hash key is not defined with a <var>DEFINE</var> command. Specify the desired field description for the hash key in the <var>INITIALIZE</var> command. Hash key fields cannot have the <var>CODED</var>, <var>INVISIBLE</var>, <var>BINARY</var>, <var>FLOAT</var>, or <var>KEY</var> attributes, and they cannot have the <var>UPDATE</var> option specified for them. [[Initializing files]] provides a full description of the <var>INITIALIZE</var> command and its use with hash key fields.</p>

	==Storing records in a hash key file==		==Storing records in a hash key file==

2016-01-28T18:13:41Z

Creating a hash key file

← Older revision		Revision as of 18:13, 28 January 2016
Line 71:		Line 71:
	==Creating a hash key file==		==Creating a hash key file==
	<p>		<p>
	A hash key file is created in the normal way, as described in ~~the~~ file ~~creation chapter~~. Set the <var>FILEORG</var> parameter at this time.</p>		A hash key file is created in the normal way, as described in [[Creating a file]]. Set the <var>FILEORG</var> parameter at this time.</p>

	===Initializing hash key files===		===Initializing hash key files===

2015-04-13T21:14:08Z

BSIZE parameter

← Older revision		Revision as of 21:14, 13 April 2015
Line 30:		Line 30:
	===BSIZE parameter===		===BSIZE parameter===
	<p>		<p>
	<var>[[BSIZE parameter\|BSIZE]]</var> determines the number of pages to be assigned to Table B. Its computation is described in [[File ~~size calculation~~]] .</p>		<var>[[BSIZE parameter\|BSIZE]]</var> determines the number of pages to be assigned to Table B. Its computation is described in [[File sizing introduction]] .</p>
	<p>		<p>
	<var>BSIZE</var> must be computed particularly carefully, because the size of a hash key file's Table B cannot be changed with an <var>INCREASE</var> command. If Table B fills up, the entire file must be reloaded. </p>		<var>BSIZE</var> must be computed particularly carefully, because the size of a hash key file's Table B cannot be changed with an <var>INCREASE</var> command. If Table B fills up, the entire file must be reloaded. </p>

2015-03-02T20:24:01Z

add link

← Older revision		Revision as of 20:24, 2 March 2015
Line 21:		Line 21:
	<li>Value of a record's hash key field cannot be changed in any way. You can, however, delete the entire record and store it again with a different hash key value.</li>		<li>Value of a record's hash key field cannot be changed in any way. You can, however, delete the entire record and store it again with a different hash key value.</li>

	<li>Special forms of the SOUL [[Data maintenance#STORE RECORD statement\|STORE RECORD statement]] and the Host Language <var>IFSTOR</var> and <var>IFBREC</var> functions allow a hash key to be specified for a new record. See the <var class="book">Rocket Model 204 Host Language Interface Reference Manual</var> for details. </li>		<li>Special forms of the SOUL [[Data maintenance#STORE RECORD statement\|STORE RECORD statement]] and the Host Language <var>IFSTOR</var> and <var>IFBREC</var> functions allow a hash key to be specified for a new record. See the <var class="book">[[Media:M204 HLIReference V75.pdf\|Rocket Model 204 Host Language Interface Reference Manual]]</var> for details. </li>
	</ul>		</ul>

2015-01-13T20:13:26Z

more conversion cleanup

2014-04-14T21:18:10Z

more conversion cleanup

2014-01-22T21:43:06Z

← Older revision		Revision as of 21:43, 22 January 2014
Line 348:		Line 348:


	[[Category:~~File management~~]]		[[Category:Sorted and hash key FILEORG files]]

2014-01-22T21:37:58Z

← Older revision		Revision as of 21:37, 22 January 2014
Line 349:		Line 349:

	[[Category:File management]]		[[Category:File management]]
	~~[[Category:Sorted and hash key FILEORG files]]~~