DELETE command: Field - Revision history

JAL: /* Large Object data support */ typo

2016-09-01T18:33:34Z

Large Object data support: typo

← Older revision		Revision as of 18:33, 1 September 2016
Line 38:		Line 38:
	====Large Object data support====		====Large Object data support====
	<p>		<p>
	The <var>DELETE FIELD</var> command supports the Large Object data ~~type~~, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		The <var>DELETE FIELD</var> command supports the Large Object data types, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>

	====OI CHUNK fields====		====OI CHUNK fields====

JAL at 01:24, 11 July 2014

2014-07-11T01:24:01Z

← Older revision		Revision as of 01:24, 11 July 2014
Line 6:		Line 6:
	<dd>Deletes a field from a <var class="product">Model 204</var> file		<dd>Deletes a field from a <var class="product">Model 204</var> file
	</dl>		</dl>

	==Syntax==		==Syntax==
	<p class="syntax">DELETE FIELD <~~var~~ class="term">fieldname</~~var~~>		<p class="syntax">DELETE FIELD <span class="term">fieldname</span>
	</p>		</p>

	~~<b>~~Where~~:</b>~~		Where <var class="term">fieldname</var> is the name of a field in the currently open <var class="product">Model 204</var> file.
	<var class="term">fieldname</var> is the name of a field in the currently open <var class="product">Model 204</var> file.

	==Example==		==Example==
	<p class="code">DELETE FIELD EMPID		<p class="code">DELETE FIELD EMPID
	</p>		</p>

	==Usage notes==		==Usage notes==
	<p>When a field is deleted, <var class="product">Model 204</var> removes the definition of the field and all occurrences of data for that field. </p>		<ul>
	~~<p>~~Depending on the size of the file and the field type, a DELETE FIELD command might take a long time to complete.</p>		<li>When a field is deleted, <var class="product">Model 204</var> removes the definition of the field and all occurrences of data for that field.
	<p>You cannot delete record security fields, sort, or hash key fields. If the specified field is in a <var class="product">Model 204</var> file with record security, the file manager must have record security override privileges.</p>		<p>
	<p>When it processes DELETE FIELD, <var class="product">Model 204</var> ends any update unit in progress and begins a non-backoutable update unit. ~~For more information about~~ <var class="product">Model 204</var> ~~update units~~, ~~see the <i>~~<var ~~class="product"~~>~~Model 204~~</var> ~~File Manager's Guide~~</i>. </p>		Depending on the size of the file and the field type, a <var>DELETE FIELD</var> command might take a long time to complete.</p></li>

			<li>You cannot delete record security fields, sort, or hash key fields. If the specified field is in a <var class="product">Model 204</var> file with record security, the file manager must have record security override privileges.</li>

			<li>When it processes <var>DELETE FIELD</var>, <var class="product">Model 204</var> ends any update unit in progress and begins a non-backoutable [[File integrity and recovery#Update units and transactions\|update unit]]. </li>

			<li>As of <var class="product">Model 204</var> V7.5, <var>DELETE FIELD</var> does not allow deletion of fields referred to by an existing [[Field design#CONCATENATION-OF .28CAT.29 attribute\|CONCATENATION-OF (CAT)]] or [[Field design#Counting occurrences of a field\|COUNT-OCCURRENCES-OF (CTO)]] field. </li>
			</ul>

	====Handling the date/time stamp field in a file====		====Handling the date/time stamp field in a file====
	<p>The DELETE FIELD command is prohibited for the DTSFN field in a file when the FOPT=X'10' is set. Attempting to do so results in the following message:</p>		<p>
			The <var>DELETE FIELD</var> command is prohibited for the DTSFN field in a file when the <var>FOPT</var> X'10' bit is set. Attempting to do so results in the following message:</p>
	<p class="code">M204.2727: CAN'T DELETE DTS FIELD WHEN FOPT=X'10' IS ON		<p class="code">M204.2727: CAN'T DELETE DTS FIELD WHEN FOPT=X'10' IS ON
	</p>		</p>

	====Large Object data support====		====Large Object data support====
	<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		<p>
			The <var>DELETE FIELD</var> command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>

	====OI CHUNK fields====		====OI CHUNK fields====

JDamon: /* CHUNK fields */

2013-10-11T17:49:11Z

CHUNK fields

← Older revision		Revision as of 17:49, 11 October 2013
Line 29:		Line 29:
	<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>

	====CHUNK fields====		====OI CHUNK fields====
	Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.		Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.

ELowell: /* CTO and CAT fields */

2013-10-11T15:17:46Z

CTO and CAT fields

← Older revision		Revision as of 15:17, 11 October 2013
Line 32:		Line 32:
	Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.		Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.

	~~====CTO and CAT fields====~~
	~~As of Model 204 version 7.5, before deleting COUNT-OCCURRENCES-OF (CTO) and CONCATENATION-OF (CAT) fields, you must first delete the fields they depend on.~~

	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* CHUNK fields */

2013-10-10T20:11:20Z

CHUNK fields

← Older revision		Revision as of 20:11, 10 October 2013
Line 31:		Line 31:
	====CHUNK fields====		====CHUNK fields====
	Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.		Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.

			====CTO and CAT fields====
			As of Model 204 version 7.5, before deleting COUNT-OCCURRENCES-OF (CTO) and CONCATENATION-OF (CAT) fields, you must first delete the fields they depend on.

	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* CHUNK fields */

2013-10-09T15:32:51Z

CHUNK fields

← Older revision		Revision as of 15:32, 9 October 2013
Line 30:		Line 30:

	====CHUNK fields====		====CHUNK fields====
	Deleting [[DEFINE FIELD command#CHUNK attribute\|OI chunk]] and OI chunk target fields is not allowed.		Deleting OI [[DEFINE FIELD command#CHUNK attribute\|chunk]] and OI chunk target fields is not allowed.

	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* OI CHUNK fields */

2013-10-09T15:30:34Z

OI CHUNK fields

← Older revision		Revision as of 15:30, 9 October 2013
Line 29:		Line 29:
	<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>

	====OI CHUNK fields====		====CHUNK fields====
	Deleting [[DEFINE FIELD command#CHUNK attribute\|OI chunk]] and OI chunk target fields is not allowed.		Deleting [[DEFINE FIELD command#CHUNK attribute\|OI chunk]] and OI chunk target fields is not allowed.

	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* CHUNK fields */

2013-10-09T15:09:56Z

CHUNK fields

← Older revision		Revision as of 15:09, 9 October 2013
Line 29:		Line 29:
	<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>

	====CHUNK fields====		====OI CHUNK fields====
	Deleting [[DEFINE FIELD command#CHUNK attribute\|~~CHUNK~~]] and ~~CHUNK~~ target fields is not allowed.		Deleting [[DEFINE FIELD command#CHUNK attribute\|OI chunk]] and OI chunk target fields is not allowed.

	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* Large Object data support */

2013-08-23T21:50:48Z

Large Object data support

← Older revision		Revision as of 21:50, 23 August 2013
Line 28:		Line 28:
	====Large Object data support====		====Large Object data support====
	<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>

			====CHUNK fields====
			Deleting [[DEFINE FIELD command#CHUNK attribute\|CHUNK]] and CHUNK target fields is not allowed.

	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* Large Object data support */

2013-06-28T20:49:24Z

Large Object data support

← Older revision		Revision as of 20:49, 28 June 2013
Line 27:		Line 27:

	====Large Object data support====		====Large Object data support====
	<p>The DELETE FIELD ~~fieldname~~ command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>		<p>The DELETE FIELD command supports the Large Object data type, so you can delete a Large Object field. However, the space in Table B and Table E is not automatically available for reuse.</p>
	[[Category: File manager commands]]		[[Category: File manager commands]]
	[[Category:Commands]]		[[Category:Commands]]