ELowell at 22:13, 12 July 2016

2016-07-12T22:13:10Z

← Older revision		Revision as of 22:13, 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 21:17, 11 July 2016

2016-07-11T21:17:04Z

← Older revision		Revision as of 21:17, 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 IFDSET call (DELETE SET) deletes the records that are in a found set from a file or group.

Thread type

multipl..."

2016-07-06T21:13:01Z

Created page with " ==Summary== <dl> <dt>Description</dt> <dd>The IFDSET call (DELETE SET) deletes the records that are in a found set from a file or group.</dd> <dt>Thread type</dt> <dd>multipl..."

New page

==Summary==
<dl>
<dt>Description</dt>
<dd>The IFDSET call (DELETE SET) deletes the records that are in a found set from a file or group.</dd>
<dt>Thread type</dt>
<dd>multiple cursor IFSTRT, single cursor IFSTRT </dd>
<dt>IFCALL function number</dt>
<dd>21</dd>
</dl>

==Syntax==
IFDSET(RETCODE,SET_QUAL)
<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>SET_QUAL</td>
<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 delete records from a file or group. Specify a character string using either one of the following formats:
{IN label | ON [LIST] listname}

where: 

<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. 

<var class="term">listname</var> specifies the name of a list.
Note: The set qualifier is not a valid parameter for use with a single cursor IFSTRT thread.
</td>
</tr>
</table>

==Usage notes==

Use the IFDSET call to delete records from a file or group.
Note: You cannot use IFDSET with a sorted record set.

When FOPT=X'10' and the date/time stamp feature is installed, the IFDSET function is supported for DTS files.

There is another call, [[IFDREC (HLI function)|IFDREC]], that also deletes records from a file or group. IFDSET executes faster than IFDREC. However, with IFDSET the file storage space that is occupied by the deleted set of records is not reclaimed and the record numbers are not reused.

The IFDSET call is valid on all types of IFSTRT threads. You must specify the found set for records that are to be deleted on a multiple cursor IFSTRT thread. On a single cursor IFSTRT thread, IFDSET deletes records from the current set.

==Coding example (COBOL)==
WORKING-STORAGE SECTION.
01 ARGS-FOR-CALL.
05 RETCODE PIC 9(5) COMP SYNC.
05 DEL-SET PIC X(10) VALUE "IN PREVFD;".
.
.
.
PROCEDURE DIVISION.
.
.
.
CALL "IFDSET" USING RETCODE, DEL-SET.

Note: The example above illustrates the use of the set qualifier parameter (DEL-SET), which is available for use only with a multiple cursor IFSTRT thread. 

[[Category: HLI functions]]

IFDSET (HLI function) - Revision history

ELowell at 22:13, 12 July 2016

ELowell at 21:17, 11 July 2016

ELowell: Created page with " ==Summary== Description The IFDSET call (DELETE SET) deletes the records that are in a found set from a file or group. Thread type multipl..."

ELowell: Created page with " ==Summary==

Description

The IFDSET call (DELETE SET) deletes the records that are in a found set from a file or group.

Thread type

multipl..."