JALWiccan: Automatically generated page update

2017-04-07T21:32:55Z

Automatically generated page update

← Older revision		Revision as of 21:32, 7 April 2017
Line 74:		Line 74:
	</table>		</table>
	<p>		<p>
	For more information about Model 204 field security, see [[~~Security~~#Field-level security\|Field-level security]].</p>		For more information about Model 204 field security, see [[Model 204 security features#Field-level security\|Field-level security]].</p>

	==Coding example (COBOL)==		==Coding example (COBOL)==

ELowell at 22:09, 12 July 2016

2016-07-12T22:09:38Z

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

2016-07-11T21:13:09Z

← Older revision		Revision as of 21:13, 11 July 2016
Line 1:		Line 1:

	~~==IFDELF~~ 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 " ==IFDELF call -mc,sc== ==Summary==

Description

The IFDELF call (DELETE FIELD) deletes a Model 204 field definition and all occurrences of data for that fie..."

2016-07-06T16:48:59Z

Created page with " ==IFDELF call -mc,sc== ==Summary== <dl> <dt>Description</dt> <dd>The IFDELF call (DELETE FIELD) deletes a Model 204 field definition and all occurrences of data for that fie..."

New page

==IFDELF call -mc,sc==

==Summary==
<dl>
<dt>Description</dt>
<dd>The IFDELF call (DELETE FIELD) deletes a Model 204 field definition and all occurrences of data for that field. IFDELF requires Model 204 file manager privileges. </dd>
<dt>Thread type</dt>
<dd>multiple cursor IFSTRT, single cursor IFSTRT </dd>
<dt>IFCALL function number</dt>
<dd>62</dd>
</dl>

==Syntax==
IFDELF(RETCODE,FIELD_NAME,FILE_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>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. Specify a character string variable.</td>
</tr>
<tr>
<td>FILE_SPEC</td>
<td>[I,s,o] The file specification is an optional input parameter for use only with a multiple cursor IFSTRT thread for specifying the name of the Model 204 file containing the field that is to be deleted. Specify the name of the file as a short character string using the following format:
IN [FILE] filename

The specified file must be open on the thread, otherwise the call is unsuccessful and Model 204 returns a completion code of 4.
</td>
</tr>
</table>

==Usage notes==

The IFDELF call is valid on all types of IFSTRT threads. Use the IFDELF call to delete field definitions except for the following types of fields:
<ul>
<li>Record security is defined using the field</li>
<li>The field is defined as a sort key</li>
<li>The field is used as a hash key</li>
</ul>

Note: The file context can change on a multiple cursor thread and, if the file specification parameter (FILE_SPEC) is omitted, IFDELF deletes the field definition for the default file on the thread (that is, the last file opened).

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

The IFDELF call requires Model 204 file manager privileges. Additional privileges are required for the following security conditions:
<table>
<tr class="head">
<th>Type of security</th>
<th>Required privileges</th>
</tr>
<tr>
<td>File defined with record security</td>
<td>Record security override</td>
</tr>
<tr>
<td>Security level field definition</td>
<td>Field level security (FLS) allows update access</td>
</tr>
</table>

For more information about Model 204 field security, see [[Security#Field-level security|Field-level security]].

==Coding example (COBOL)==
WORKING-STORAGE SECTION.
01 CALL-ARGS.
05 RETCODE PIC 9(5) COMP SYNC.
05 STATUS PIC X(7) VALUE "STATUS;".
.
.
.
PROCEDURE DIVISION.
.
.
.
CALL "IFDELF" USING RETCODE, STATUS.

[[Category: HLI functions]]

IFDELF (HLI function) - Revision history

JALWiccan: Automatically generated page update

ELowell at 22:09, 12 July 2016

ELowell at 21:13, 11 July 2016

ELowell: Created page with " ==IFDELF call -mc,sc== ==Summary== Description The IFDELF call (DELETE FIELD) deletes a Model 204 field definition and all occurrences of data for that fie..."

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

Description

The IFDELF call (DELETE FIELD) deletes a Model 204 field definition and all occurrences of data for that fie..."