https://m204wiki.rocketsoftware.com/index.php?title=IFFAC_(HLI_function)&feed=atom&action=historyIFFAC (HLI function) - Revision history2024-03-29T15:48:37ZRevision history for this page on the wikiMediaWiki 1.40.1https://m204wiki.rocketsoftware.com/index.php?title=IFFAC_(HLI_function)&diff=116762&oldid=prevDme: /* Syntax */2018-09-04T16:00:00Z<p><span dir="auto"><span class="autocomment">Syntax</span></span></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 16:00, 4 September 2018</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l34">Line 34:</td>
<td colspan="2" class="diff-lineno">Line 34:</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><tr></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><tr></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><td>FIND_SPEC</td></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><td>FIND_SPEC</td></div></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><td>[I,c,r] The find specification is a required input parameter which is the selection criteria to be used for retrieving records. Specify a character string. See [[#FIND_SPEC|<del style="font-weight: bold; text-decoration: none;">FIND_SPEC</del>]] <del style="font-weight: bold; text-decoration: none;">for a detailed description of the find specification used for the </del>IFFIND <del style="font-weight: bold; text-decoration: none;">call that is also valid for </del>IFFAC.</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><td>[I,c,r] The find specification is a required input parameter which is the selection criteria to be used for retrieving records. Specify a character string. See <ins style="font-weight: bold; text-decoration: none;">the <var>IFFIND</var> </ins>[[<ins style="font-weight: bold; text-decoration: none;">IFFIND (HLI function)</ins>#FIND_SPEC|<ins style="font-weight: bold; text-decoration: none;">Find spec description</ins>]]<ins style="font-weight: bold; text-decoration: none;">; those details apply to both <var></ins>IFFIND<ins style="font-weight: bold; text-decoration: none;"></var> and <var></ins>IFFAC<ins style="font-weight: bold; text-decoration: none;"></var></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><p></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><p></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>The file context can change on a multiple cursor thread and, if the file specification is omitted, IFFAC processes records from the file or group that is the default on the thread at the time that the IFFAC is compiled. </p></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>The file context can change on a multiple cursor thread and, if the file specification is omitted, IFFAC processes records from the file or group that is the default on the thread at the time that the IFFAC is compiled. </p></div></td></tr>
</table>Dmehttps://m204wiki.rocketsoftware.com/index.php?title=IFFAC_(HLI_function)&diff=89162&oldid=prevELowell at 22:52, 12 July 20162016-07-12T22:52:46Z<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:52, 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=IFFAC_(HLI_function)&diff=88782&oldid=prevELowell at 22:02, 11 July 20162016-07-11T22:02:40Z<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:02, 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 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=IFFAC_(HLI_function)&diff=86905&oldid=prevELowell: Created page with " ==Summary== <dl> <dt>Description</dt> <dd>The IFFAC call (FIND AND COUNT) creates a found set and returns the record count in an output parameter.</dd> <dt>Thread type</dt> <..."2016-07-07T18:49:50Z<p>Created page with " ==Summary== <dl> <dt>Description</dt> <dd>The IFFAC call (FIND AND COUNT) creates a found set and returns the record count in an output parameter.</dd> <dt>Thread type</dt> <..."</p>
<p><b>New page</b></p><div><br />
==Summary==<br />
<dl><br />
<dt>Description</dt><br />
<dd>The IFFAC call (FIND AND COUNT) creates a found set and returns the record count in an output parameter.</dd><br />
<dt>Thread type</dt><br />
<dd>multiple cursor IFSTRT, single cursor IFSTRT</dd><br />
<dt>IFCALL function number</dt><br />
<dd>126</dd><br />
</dl><br />
<br />
==Syntax==<br />
<p class="syntax">IFFAC(RETCODE,FIND_SPEC,COUNT,FAC_NAME,%VARBUF,%VARSPEC)</p><br />
<dl><br />
<dt>Compile-only form</dt><br />
<dd>IFCALL function number: 127<br />
<p class="syntax">IFFACC(RETCODE,FIND_SPEC,FAC_NAME)</p></dd><br />
<dt>Execute-only form</dt><br />
<dd> IFCALL function number: 128<br />
<p class="syntax">IFFACE(RETCODE,COUNT,FAC_NAME,%VARBUF,%VARSPEC)</p></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>FIND_SPEC</td><br />
<td>[I,c,r] The find specification is a required input parameter which is the selection criteria to be used for retrieving records. Specify a character string. See [[#FIND_SPEC|FIND_SPEC]] for a detailed description of the find specification used for the IFFIND call that is also valid for IFFAC.<br />
<p><br />
The file context can change on a multiple cursor thread and, if the file specification is omitted, IFFAC processes records from the file or group that is the default on the thread at the time that the IFFAC is compiled. </p><br />
</td><br />
</tr><br />
<tr><br />
<td>COUNT</td><br />
<td>[O,i,r] The count parameter is a required parameter which specifies the location of the output parameter for the return count value. Specify an integer variable. Model 204 returns the record count as a fullword binary number.</td><br />
</tr><br />
<tr><br />
<td>FAC_NAME</td><br />
<td>[I,s,r/o] The name of the IFFAC compilation is an input parameter that is required for use with a multiple cursor IFSTRT thread, and is only required for a single cursor IFSTRT thread if using the Compiled IFAM facility (IFFACC and IFFACE). Model 204 saves the compilation using this name.<br />
<p><br />
Specify the name as unique, and as a short character string (maximum 32 characters).</p><br />
<ul><br />
<li>On a single cursor IFSTRT thread, any characters <i>except</i> the following are valid in the name: blank, comma, parenthesis, equal sign, or semicolon.</li> <br />
<li>On a multiple cursor IFSTRT thread, the first character in the name must be alphanumeric, and the name must begin with a letter (A-Z or a-z) which may be followed by a letter, a digit (0-9), a period (.), or underscore (_).</li><br />
</ul><br />
<p class="note"><b>Note:</b> A null value is equivalent to omitting the name parameter, and is not valid for a multiple cursor thread.</p><br />
</td><br />
</tr><br />
<tr><br />
<td>%VARBUF</td><br />
<td>[I,c,o] The variable buffer is an optional input parameter that addresses a data area which accommodates up to 255 bytes of data per value. The buffer contains values which are defined by the %VARSPEC parameter, below, to be assigned to %variables. Specify a character string. For more information, see [[Using variables and values in computation]].</td><br />
</tr><br />
<tr><br />
<td nowrap>%VARSPEC</td><br />
<td>[I,c,o] The variable specification describes the format of the data that is contained in the %variable parameter and lists the %variables to be assigned. %VARSPEC specifies the contents of the variable buffer, described above. Specify a character string which follows a LIST, DATA, or EDIT syntax.<br />
<p><br />
%VARSPEC is a required input parameter if %VARBUF is specified.</p><br />
</td><br />
</tr><br />
</table><br />
<br />
==Usage notes==<br />
<p><br />
Use the IFFAC call to retrieve records and to obtain a count of the records that meet the retrieval conditions.</p><br />
<br />
<p class="note"><b>Note:</b> The IFFAC call is permitted on all types of IFSTRT threads and is useful for reducing CRAM overhead.</p><br />
<p><br />
The IFFAC call is the equivalent of the FIND AND PRINT COUNT statement in SOUL in the host language environment. For information about the FIND AND PRINT COUNT statement, see<br />
[[Basic SOUL statements and commands#Counting records|Counting records]].</p><br />
<br />
===Processing records from a found set===<br />
<p><br />
There are differences between single cursor and multiple cursor IFSTRT threads in processing records from a found set. </p><br />
<p><br />
When a set is found on a single cursor IFSTRT thread, and while it is the current set, you can use IFGET to retrieve individual records. On a single cursor IFSTRT thread, you must save the current found set on a list before issuing any call which creates a new set if you want to access the previously found records. </p><br />
<p><br />
On a multiple cursor thread, use IFOCUR to open a cursor to a found set any time after it is established and use the IFFTCH call to retrieve individual records.</p><br />
<br />
==Coding example (COBOL)==<br />
<p class="code">WORKING-STORAGE SECTION.<br />
01 CALL-ARGS.<br />
05 RETCODE PIC 9(5) COMP SYNC.<br />
05 COUNT PIC 9(5) COMP SYNC.<br />
05 FDSPEC PIC X(12) VALUE "MAKE='FORD';END;".<br />
05 FDNAME PIC X(7) VALUE "FDFORD;".<br />
.<br />
.<br />
.<br />
PROCEDURE DIVISION.<br />
<br />
.<br />
.<br />
.<br />
CALL "IFFAC" USING RETCODE, FDSPEC, COUNT, FDNAME.</p><br />
<br />
[[Category: HLI functions]]</div>ELowell