ELowell at 22:55, 12 July 2016

2016-07-12T22:55:23Z

← Older revision		Revision as of 22:55, 12 July 2016
Line 1:		Line 1:
	The conventions used on this page are described in [[HLI: Function ~~call list~~#Function call notation conventions\|Function call notation conventions]].		The conventions used on this page are described in [[HLI: Function summary#Function call notation conventions\|Function call notation conventions]].

	==Summary==		==Summary==

ELowell at 22:05, 11 July 2016

2016-07-11T22:05:26Z

← Older revision		Revision as of 22:05, 11 July 2016
Line 1:		Line 1:
	~~==IFFNDX~~ call ~~-mc,sc==~~		The conventions used on this page are described in [[HLI: Function call list#Function call notation conventions\|Function call notation conventions]].

	==Summary==		==Summary==

ELowell: Created page with "==IFFNDX call -mc,sc== ==Summary==

Description

The IFFNDX call (FIND EXCLUSIVE) selects records from a Model 204 file or group, enqueuing in exclusive mode,..."

2016-07-07T19:45:12Z

Created page with "==IFFNDX call -mc,sc== ==Summary== <dl> <dt>Description</dt> <dd>The IFFNDX call (FIND EXCLUSIVE) selects records from a Model 204 file or group, enqueuing in exclusive mode,..."

New page

==IFFNDX call -mc,sc==

==Summary==
<dl>
<dt>Description</dt>
<dd>The IFFNDX call (FIND EXCLUSIVE) selects records from a Model 204 file or group, enqueuing in exclusive mode, and creates a found set.</dd>
<dt>Thread type</dt>
<dd>multiple cursor IFSTRT, single cursor IFSTRT</dd>
<dt>IFCALL function number</dt>
<dd>56</dd>
</dl>

==Syntax==
IFFNDX|IFFDX(RETCODE,FIND_SPEC,TIME_SPEC,FNDX_NAME,%VARBUF,%VARSPEC)
<dl>
<dt>Compile-only form</dt>
<dd>IFCALL function number: 57
IFFNDXC|IFFDXC(RETCODE,FIND_SPEC,FNDX_NAME)</dd>
<dt>Execute-only form</dt>
<dd> IFCALL function number: 58
IFFNDXE|IFFDXE(RETCODE,TIME_SPEC,FNDX_NAME,%VARBUF,%VARSPEC)</dd>
</dl>

Specify the parameters in the syntax order shown above.
<table>
<tr class="head">
<th>Parameter</th>
<th>Description</th>
</tr>
<tr>
<td>RETCODE</td>
<td>[O,i,r] The Model 204 return code is the required first parameter. The code is a binary integer value.</td>
</tr>
<tr>
<td>FIND_SPEC</td>
<td>[I,c,r] The find specification is a required input parameter which is the selection criteria to be used for retrieving records. Specify the selection criteria as a character string.

See [[#FIND_SPEC|FIND_SPEC]] for a detailed description of the find specification used for IFFIND that is also valid for IFFNDX. 
</td>
</tr>
<tr>
<td>TIME_SPEC</td>
<td>[I,i,r] The time specification is a required input parameter. Specify an integer value which is the number of times to try the find in the event of an enqueuing conflict; the wait time is in 3-second periods.</td>
</tr>
<tr>
<td>FNDX_NAME</td>
<td>[I,s,r/o] The name of the IFFNDX 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 (IFFNDXC and IFFNDXE). Model 204 saves the compilation using this name.

Specify the name as unique, and as a short character string (maximum 32 characters).
<ul>
<li>On a single cursor IFSTRT thread, any characters except the following are valid in the name: blank, comma, parenthesis, equal sign, or semicolon.</li>
<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>
</ul>
Note: A null value is equivalent to omitting the name parameter, and is not valid for a multiple cursor thread.
</td>
</tr>
<tr>
<td>%VARBUF</td>
<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 information about %variables, see [[Using variables and values in computation]].
</td>
</tr>
<tr>
<td>%VARSPEC</td>
<td>[I,c,o] The variable specification describes the format of the data that is contained in the %VARBUF 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.

%VARSPEC is a required input parameter if %VARBUF is specified.
</td>
</tr>
</table>

==Usage notes==

Use the IFFNDX call to retrieve records and to hold the found set in exclusive mode. The find specification is based on a specified combination of retrieval conditions and is identical to the one that is used with the IFFIND call.

If a call to IFFNDX results in an enqueuing conflict, Model 204 waits at most three seconds and then tries again, for as many times as specified in the time parameter (the wait time is in 3-second periods). After trying unsuccessfully for the number of times specified in the time parameter, Model 204 returns a completion code of 3 to the HLI program.

For more information, see [[ENQRETRY parameter]].

==Coding example (COBOL)==
WORKING-STORAGE SECTION.
01 CALL-ARGS.
05 RETCODE PIC 9(5) COMP SYNC.
05 QUAL-1 PIC X(75) VALUE 'SEX=FEMALE;
OCCUPATION=DOCTOR OR DENTIST;
CITY=BOSTON;NAME LIKE "PAT*";END;'.
05 NUMRTRY PIC 9(5) COMP SYNC VALUE 3.
.
.
.
PROCEDURE DIVISION.
.
.
.
CALL "IFFNDX" USING RETCODE, QUAL-1, NUMRTRY.

[[Category: HLI functions]]

IFFNDX (HLI function) - Revision history

ELowell at 22:55, 12 July 2016

ELowell at 22:05, 11 July 2016

ELowell: Created page with "==IFFNDX call -mc,sc== ==Summary== Description The IFFNDX call (FIND EXCLUSIVE) selects records from a Model 204 file or group, enqueuing in exclusive mode,..."

ELowell: Created page with "==IFFNDX call -mc,sc== ==Summary==

Description

The IFFNDX call (FIND EXCLUSIVE) selects records from a Model 204 file or group, enqueuing in exclusive mode,..."