ELowell at 19:37, 13 July 2016

2016-07-13T19:37:13Z

← Older revision		Revision as of 19:37, 13 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:56, 11 July 2016

2016-07-11T22:56:47Z

← Older revision		Revision as of 22:56, 11 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]].

	==Summary==		==Summary==

ELowell: Created page with " ==Summary==

Description

The IFRRFLS call (REMOVE RECORDS FROM LIST) removes records from a particular list on the current thread.

Thread type
..."

2016-07-08T20:42:48Z

Created page with " ==Summary== <dl> <dt>Description</dt> <dd>The IFRRFLS call (REMOVE RECORDS FROM LIST) removes records from a particular list on the current thread.</dd> <dt>Thread type</dt>..."

New page

==Summary==
<dl>
<dt>Description</dt>
<dd>The IFRRFLS call (REMOVE RECORDS FROM LIST) removes records from a particular list on the current thread.</dd>
<dt>Thread type</dt>
<dd>multiple cursor IFSTRT</dd>
<dt>IFCALL function number</dt>
<dd>110</dd>
</dl>

==Syntax==
IFRRFLS|IFRFLS(RETCODE,LIST_SPEC)

<dl>
<dt>Compile-only form</dt>
<dd>Not available</dd>
<dt>Execute-only form</dt>
<dd>Not available</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>LIST_SPEC</td>
<td>[I,c,r] The list specification is a required input parameter that specifies an existing set of found records to be matched against and removed from a particular list. Specify the record set and the list as a character string using the following format:
set qualifier FROM [LIST] listname

where:

<var class="term">set qualifier</var> is required and specifies the name of a previously established found set or list using the IN <var class="term">label</var> format, where <var class="term">label</var> is the name of a saved IFFIND, IFFNDX, IFFWOL, IFFAC, IFSORT, IFFDV, or IFSRTV compilation from a previously compiled call. 

<var class="term">listname</var> is required and specifies the name of a particular list from which records (having a match in the found set) will be removed.
</td>
</tr>
</table>

==Usage notes==

Use the IFRRFLS call to delete from a particular list any records that match those in the specified found set or list.

The IFRRFLS call is the equivalent of the REMOVE RECORDS FROM LIST statement in SOUL in the host language multiple cursor environment. For information about the REMOVE RECORDS FROM LIST statement, see [[DML statements in Parallel Query Option/204]].

==Coding example (COBOL)==
WORKING-STORAGE SECTION.
01 CALL-ARGS.
05 RETCODE PIC 9(5) COMP SYNC.
05 LISTSPEC PIC X(22) VALUE "IN PREVFD FROM LIST L;".
.
.
.
PROCEDURE DIVISION.
.
.
.
CALL "IFRRFLS" USING RETCODE, LISTSPEC.

[[Category: HLI functions]]

IFRRFLS (HLI function) - Revision history

ELowell at 19:37, 13 July 2016

ELowell at 22:56, 11 July 2016

ELowell: Created page with " ==Summary== Description The IFRRFLS call (REMOVE RECORDS FROM LIST) removes records from a particular list on the current thread. Thread type..."

ELowell: Created page with " ==Summary==

Description

The IFRRFLS call (REMOVE RECORDS FROM LIST) removes records from a particular list on the current thread.

Thread type
..."