https://m204wiki.rocketsoftware.com/index.php?action=history&feed=atom&title=IFFILE_%28HLI_function%29IFFILE (HLI function) - Revision history2026-04-24T09:20:45ZRevision history for this page on the wikiMediaWiki 1.43.1https://m204wiki.rocketsoftware.com/index.php?title=IFFILE_(HLI_function)&diff=89164&oldid=prevELowell at 22:53, 12 July 20162016-07-12T22:53:27Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:53, 12 July 2016</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The conventions used on this page are described in [[HLI: Function <del style="font-weight: bold; text-decoration: none;">call list</del>#Function call notation conventions|Function call notation conventions]].</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The conventions used on this page are described in [[HLI: Function <ins style="font-weight: bold; text-decoration: none;">summary</ins>#Function call notation conventions|Function call notation conventions]].</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Summary==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Summary==</div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=IFFILE_(HLI_function)&diff=88786&oldid=prevELowell at 22:03, 11 July 20162016-07-11T22:03:33Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:03, 11 July 2016</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">The conventions used on this page are described in [[HLI: Function call list#Function call notation conventions|Function call notation conventions]].</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Summary==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Summary==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><dl></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><dl></div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=IFFILE_(HLI_function)&diff=86907&oldid=prevELowell: Created page with "==Summary== <dl> <dt>Description</dt> <dd>The IFFILE call (FILE) adds the specified field to each record in a found set and saves the updated records.</dd> <dt>Thread type</dt..."2016-07-07T19:03:20Z<p>Created page with "==Summary== <dl> <dt>Description</dt> <dd>The IFFILE call (FILE) adds the specified field to each record in a found set and saves the updated records.</dd> <dt>Thread type</dt..."</p>
<p><b>New page</b></p><div>==Summary==<br />
<dl><br />
<dt>Description</dt><br />
<dd>The IFFILE call (FILE) adds the specified field to each record in a found set and saves the updated records.</dd><br />
<dt>Thread type</dt><br />
<dd>multiple cursor IFSTRT, single cursor IFSTRT</dd><br />
<dt>IFCALL function number</dt><br />
<dd>22</dd><br />
</dl><br />
<br />
==Syntax==<br />
<p class="syntax">IFFILE(RETCODE,FIELD_SPEC,SET_QUAL)</p><br />
<dl><br />
<dt>Compile-only form</dt><br />
<dd>Not available</dd><br />
<dt>Execute-only form</dt><br />
<dd>Not available</dd><br />
</dl><br />
<br />
<p>Specify the parameters in the syntax order shown above.</p><br />
<table><br />
<tr class="head"><br />
<th>Parameter</th><br />
<th>Description</th><br />
</tr><br />
<tr><br />
<td>RETCODE</td><br />
<td>[O,i,r] The Model 204 return code is the required first parameter. The code is a binary integer value.</td><br />
</tr><br />
<tr><br />
<td>FIELD_SPEC</td><br />
<td>[I,c,r] The field specification is a required input parameter which specifies the name and value pair for the field that will be added to the records in the set. Specify a character string using the following name=value pair format:<br />
<p class="syntax"><span class="term">fieldname</span>=<span class="term">fieldvalue</span>;</p><br />
<p><br />
where:</p><br />
<p><br />
<var class="term">fieldname</var> is the name of the predefined Model 204 field to be added to each record in the set. You may specify only one field per IFFILE call. The field must be predefined to Model 204 as having both KEY and INVISIBLE attributes. Specify the name as a character string, up to 255 characters in length.</p><br />
<p><br />
<var class="term">fieldvalue</var> is the value for the specified field in the pair. A value is required. Values may be specified in decimal form, such as 193, in hexadecimal form, such as X`C1', or in character form, such as C`A'.</p><br />
</td><br />
</tr><br />
<tr><br />
<td>SET_QUAL</td><br />
<td>[I,c,r] The set qualifier is available only for use with a multiple cursor IFSTRT thread and it is required for specifying the record set or list that will be used to add fields to records in a file or group. Specify a character string using either one of the following formats:<br />
<p class="syntax">{IN <span class="term">label</span> | ON [LIST} <span class="term">listname</span>}</p><br />
<p><br />
where: </p><br />
<p><br />
<var class="term">label</var> is the name of a saved IFFIND, IFFNDX, IFFWOL, or IFFAC compilation from the previously compiled call which established the record set. </p><br />
<p><var class="term">listname</var> specifies the name of a list which contains the found set.</p><br />
<p class="note"><b>Note:</b> The set qualifier is not a valid parameter for use with a single cursor IFSTRT thread.</p><br />
</td><br />
</tr><br />
</table><br />
<br />
==Usage notes==<br />
<p><br />
Use the IFFILE call to update and retain a set of records for future use. The IFFILE call adds the specified field to all the records that are in the found set. IFFILE does not enqueue on a set of records. Note that you cannot use IFFILE with a sorted record set.</p><br />
<p><br />
When FOPT=X'10' and the date/time stamp feature is installed, the IFFILE function is supported for DTS files.</p><br />
<p><br />
Once records are updated with the IFFILE call, you can retrieve all the records in the found set by referencing the added field in a retrieval call. Overall, this is more efficient than updating records one at a time.</p><br />
<p><br />
The IFFILE call is valid on all types of IFSTRT threads. You must specify the found set of records that are to be updated on a multiple cursor IFSTRT thread. On a single cursor IFSTRT thread, IFFILE updates records using the found set that is current.</p><br />
<br />
<p class="note"><b>Note:</b> IFFILE deletes a field from a record in a file or group if the field already exists. Use IFFILE with caution because it can delete a field from records which are not in the current set. </p><br />
<br />
==Coding example (COBOL)==<br />
<p class="code">WORKING-STORAGE SECTION.<br />
01 ARGS-FOR-CALL. <br />
05 RETCODE PIC 9(5) COMP SYNC.<br />
05 KEY-INV-FIELD PIC X(10) VALUE "SAVREC=2;".<br />
.<br />
.<br />
.<br />
PROCEDURE DIVISION.<br />
.<br />
.<br />
.<br />
CALL "IFFILE" USING RETCODE, KEY-INV-FIELD.</p><br />
<br />
[[Category: HLI functions]]</div>ELowell