ELowell at 22:13, 12 July 2016

2016-07-12T22:13:57Z

← 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:18, 11 July 2016

2016-07-11T21:18:17Z

← Older revision		Revision as of 21:18, 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 IFDVAL call (DELETE VALUE) deletes from the current record the first occurrence of a Model 204 field that matches the specified..."

2016-07-06T21:55:38Z

Created page with " ==Summary== <dl> <dt>Description</dt> <dd>The IFDVAL call (DELETE VALUE) deletes from the current record the first occurrence of a Model 204 field that matches the specified..."

New page

==Summary==
<dl>
<dt>Description</dt>
<dd>The IFDVAL call (DELETE VALUE) deletes from the current record the first occurrence of a Model 204 field that matches the specified name=value pair.</dd>
<dt>Thread type</dt>
<dd>multiple cursor IFSTRT, single cursor IFSTRT </dd>
<dt>IFCALL function number</dt>
<dd>32</dd>
</dl>

==Syntax==
IFDVAL(RETCODE,FIELD_NAME,VALUE,CURSOR_NAME)
<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>FIELD_NAME</td>
<td>[I,c,r] The field name is a required input parameter that specifies the name of the Model 204 field to be deleted. You can specify only one field to be deleted per call. Specify a character string variable followed by a semicolon (;).</td>
</tr>
<tr>
<td>VALUE</td>
<td>[I,c,r] The value is a required input parameter that specifies the field value corresponding to the specified field name. Taken together, the field name and value form a pair for matching against the record. You can specify only one value for the field. Specify a character string variable followed by a semicolon (;).</td>
</tr>
<tr>
<td>CURSOR_NAME</td>
<td>[I,s,r] The name of the cursor is an input parameter that is available only for use with a multiple cursor IFSTRT thread and is required for specifying the record to be deleted. Specify the cursor name as a short character string, using the name previously assigned to the cursor in a corresponding IFOCUR call. See [[IFOCUR (HLI function)#CURSOR_NAME|CURSOR_NAME]] for a description of the cursor name for the IFOCUR call.
Note: The cursor name is not a valid parameter for use with a single cursor IFSTRT thread.
</td>
</tr>
</table>

==Usage notes==

Use the IFDVAL call to delete a Model 204 field that has been defined as having an INVISIBLE or VISIBLE attribute. Note the following rules:
<ul>
<li>
If a VISIBLE field is multiply occurring and the same field name = value pair occurs more than once, IFDVAL deletes only the first occurrence of the identical pairs.</li>
<li>
Use IFDVAL to delete any INVISIBLE fields for a record before using the IFDREC call to delete the record. This allows record numbers to be reused in the current file. For information about reusing record numbers, see [[File design#Reuse Record Number (X'04')|Reuse Record Number]].
</li>
</ul>
Note: You cannot use IFDVAL on a sorted record set.

The IFDVAL call is valid on all types of IFSTRT threads. On a multiple cursor IFSTRT thread, you must specify the cursor name for the record that is to be deleted. On a single cursor IFSTRT thread, IFDVAL deletes a field from the current record using the current record set. 

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

==Coding example (PL/1)==
The following PL/1 call deletes from the current record the field name = value pair COLOR = BLUE.
.
.
.
CALL IFDVAL (RETCODE, 'COLOR;','BLUE;');

[[Category: HLI functions]]

IFDVAL (HLI function) - Revision history

ELowell at 22:13, 12 July 2016

ELowell at 21:18, 11 July 2016

ELowell: Created page with " ==Summary== Description The IFDVAL call (DELETE VALUE) deletes from the current record the first occurrence of a Model 204 field that matches the specified..."

ELowell: Created page with " ==Summary==

Description

The IFDVAL call (DELETE VALUE) deletes from the current record the first occurrence of a Model 204 field that matches the specified..."