Data maintenance - Revision history

Dme: /* Adding a field group */

2019-08-17T12:43:21Z

Adding a field group

← Older revision		Revision as of 12:43, 17 August 2019
Line 1,023:		Line 1,023:
	The following subsections provide an overview of the basic operations with field groups. For additional details, see [[Processing multiply occurring fields and field groups]].		The following subsections provide an overview of the basic operations with field groups. For additional details, see [[Processing multiply occurring fields and field groups]].

	===Adding a field group===		===<b id="addFieldgroup"></b>Adding a field group===
	To add a field group, issue an ~~ADD FIELDGROUP~~ statement in a record context:		To add a field group, issue an <var>Add Fieldgroup</var> statement in a record context:
	<p class="syntax">~~FR IN LABELX~~		<p class="syntax">Fr In LabelX
	~~ADD FIELDGROUP~~ <span class="term">fieldgroupname</span>		Add Fieldgroup <span class="term">fieldgroupname</span>
	field1 = (<span class="term">value1</span> <span class="squareb">\|</span> <span class="term">expression</span>)		field1 = (<span class="term">value1</span> <span class="squareb">\|</span> <span class="term">expression</span>)
	[field2 = (<span class="term">value2</span> <span class="squareb">\|</span> <span class="term">expression</span>)		[field2 = (<span class="term">value2</span> <span class="squareb">\|</span> <span class="term">expression</span>)
	...]		...]
	~~END ADD~~		End Add
	~~END FOR~~		End For
	</p>		</p>
	The syntax of the <var class="term">fieldname=value</var> pairs inside an <var>~~ADD FIELDGROUP~~</var> statement is identical to that of a <var>~~STORE RECORD~~</var> statement. See also [[#Inserting a field group\|Inserting a field group]].		The syntax of the <var class="term">fieldname=value</var> pairs inside an <var>Add Fieldgroup</var> statement is identical to that of a <var>[[Store Record statement\|Store Record]]</var> statement. See also [[#Inserting a field group\|Inserting a field group]].

	In place of a value in the <var class="term">fieldname=value</var> pair, you can enter an expression. See [[#Expressions as field name values\|Expressions as field name values]] for details.		In place of a value in the <var class="term">fieldname=value</var> pair, you can enter an expression. See [[#Expressions as field name values\|Expressions as field name values]] for details.

	===Inserting a field group===		===Inserting a field group===
	In addition to the ADD FIELDGROUP statement, you can also issue an <var>INSERT FIELDGROUP</var> statement:		In addition to the ADD FIELDGROUP statement, you can also issue an <var>INSERT FIELDGROUP</var> statement:

Dme: /* Storing null values */

2018-12-18T11:41:39Z

Storing null values

← Older revision		Revision as of 11:41, 18 December 2018
Line 924:		Line 924:
	==Storing data in fields==		==Storing data in fields==

	===Storing null values===		===<b id="storNull"></b>Storing null values===
	<p>		<p>
	If the new value in an <var>ADD</var>, <var>CHANGE</var>, or <var>STORE</var> statement is left blank, no field is added to or stored with the record. If a field containing a null value must be added, you specify the value as an explicit null string (two single quotes with no space between them). For example: </p>		If the new value in an <var>ADD</var>, <var>CHANGE</var>, or <var>STORE</var> statement is left blank, no field is added to or stored with the record. If a field containing a null value must be added, you specify the value as an explicit null string (two single quotes with no space between them). For example: </p>

JAL: mixed case for statements

2018-07-23T18:51:19Z

mixed case for statements

← Older revision		Revision as of 18:51, 23 July 2018
Line 173:		Line 173:
	</ul>		</ul>

	==~~DELETE~~ statement==		==Delete statement==
	<p>		<p>
	The <var>~~DELETE~~</var> statement removes fields from a record. </p>		The <var>Delete</var> statement removes fields from a record. </p>

	====Syntax====		====Syntax====
	<p>		<p>
	The format of the <var>~~DELETE~~</var> statement is:</p>		The format of the <var>Delete</var> statement is:</p>
	<p class="syntax">~~DELETE~~ <span class="term">fieldname</span> [<b></b>= <span class="term">value</span> \| (<span class="term">expression</span>)]		<p class="syntax">Delete <span class="term">fieldname</span> [<b></b>= <span class="term">value</span> \| (<span class="term">expression</span>)]
	</p>		</p>
	<p>		<p>
Line 215:		Line 215:
	====Usage====		====Usage====
	<ul>		<ul>
	<li>You can use the <var>~~DELETE~~ <i>fieldname</i></var> statement on any field in a record except for a sort or hash key field. This statement can be used only within a <var>~~FOR EACH RECORD~~</var> loop. </li>		<li>You can use the <var>Delete <i>fieldname</i></var> statement on any field in a record except for a sort or hash key field. This statement can be used only within a <var>For Each Record</var> loop. </li>

	<li>If the <var>~~DELETE~~ <i>fieldname</i></var> statement is applied to a record that does not contain the field to be deleted, no action is taken on that record. </li>		<li>If the <var>Delete <i>fieldname</i></var> statement is applied to a record that does not contain the field to be deleted, no action is taken on that record. </li>

	<li>The <var>~~DELETE~~ <i>fieldname</i></var> statement is supported in remote file and scattered group contexts.</li>		<li>The <var>Delete <i>fieldname</i></var> statement is supported in remote file and scattered group contexts.</li>

	<li>The <var>~~DELETE~~ <i>fieldname</i></var> statement supports Large Object data. Processing this statement frees the Table B and Table E data.</li>		<li>The <var>Delete <i>fieldname</i></var> statement supports Large Object data. Processing this statement frees the Table B and Table E data.</li>

	<li>To use with multiply occurring fields, see [[Processing multiply occurring fields and field groups#DELETE statement\|Deleting multiply occurring fields]]. </li>		<li>To use with multiply occurring fields, see [[Processing multiply occurring fields and field groups#DELETE statement\|Deleting multiply occurring fields]]. </li>

JAL: /* Updating field groups */ add word "physical"

2018-06-12T21:03:37Z

Updating field groups: add word "physical"

← Older revision		Revision as of 21:03, 12 June 2018
Line 1,013:		Line 1,013:

	==Updating field groups==		==Updating field groups==
	<p class="note"><b>Note: </b>[[Field group (File architecture)\|~~Field~~ groups]] are supported as of Model 204 version 7.5.</p>		<p class="note"><b>Note:</b> Physical [[Field group (File architecture)\|field groups]] are supported as of Model 204 version 7.5. </p>
	<p>		<p>
	When a field group is added, a field group ID is assigned to the field group. This field group ID is unique among all field groups in the record, whether or not they have the same field group name. The ID is a number between 1 (zero is not used as an ID) and 2**32-1. The field group ID is an unsigned 32-bit integer, though only a length byte and trailing non-zero bytes are stored.</p>		When a field group is added, a field group ID is assigned to the field group. This field group ID is unique among all field groups in the record, whether or not they have the same field group name. The ID is a number between 1 (zero is not used as an ID) and 2**32-1. The field group ID is an unsigned 32-bit integer, though only a length byte and trailing non-zero bytes are stored.</p>

JAL: /* Add statement */ syntax content replaced with template

2018-05-08T21:50:03Z

Add statement: syntax content replaced with template

← Older revision		Revision as of 21:50, 8 May 2018
Line 76:		Line 76:
	<p>		<p>
	The basic format of the <var>Add</var> statement is:</p>		The basic format of the <var>Add</var> statement is:</p>
	~~<p class="syntax">~~Add ~~<span class="term">~~fieldname~~</span> = {<span class="term">value</span> <span class="squareb">\|</span> (<span class="term">expression</span>)~~} ~~</p>~~		{{Template:Add fieldname statement syntax}}
	<p>		<p>
	Where:</p>		Where:</p>

JAL: /* Add statement */ mixed case stmt

2018-05-08T20:45:07Z

Add statement: mixed case stmt

← Older revision		Revision as of 20:45, 8 May 2018
Line 87:		Line 87:
	</ul>		</ul>

	<p class="note"><b>Note:</b> For Large Object data in <var class="product">Model 204</var> V7.5 and later, a file must be defined with the <var>[[FILEORG parameter\|FILEORG]]</var> X'100' bit in order to use the above syntax. With LOB fields, the assigned value is typically held in a <var>[[Longstrings\|Longstring]]</var> variable. [[Large Object field processing for non-FILEORG X'100' files\|In non-FILEORG X'100' files, a special syntax must be used to ~~ADD~~ a LOB field.]]</p>		<p class="note"><b>Note:</b> For Large Object data in <var class="product">Model 204</var> V7.5 and later, a file must be defined with the <var>[[FILEORG parameter\|FILEORG]]</var> X'100' bit in order to use the above syntax. With LOB fields, the assigned value is typically held in a <var>[[Longstrings\|Longstring]]</var> variable. [[Large Object field processing for non-FILEORG X'100' files\|In non-FILEORG X'100' files, a special syntax must be used to Add a LOB field.]]</p>

	====Example====		====Example====

JAL: /* ADD statement */ mixed case for UL stmts

2018-05-08T20:34:04Z

ADD statement: mixed case for UL stmts

← Older revision		Revision as of 20:34, 8 May 2018
Line 69:		Line 69:
	The SOUL data maintenance statements handle one record at a time, therefore the data maintenance statements are always part of a <var>For Each Record</var> loop. The data maintenance may involve a field-value pair for the field.</p>		The SOUL data maintenance statements handle one record at a time, therefore the data maintenance statements are always part of a <var>For Each Record</var> loop. The data maintenance may involve a field-value pair for the field.</p>

	==~~ADD~~ statement==		==Add statement==
	<p>		<p>
	The <var>~~ADD~~</var> statement adds a new occurrence of a field and/or value to a record.</p>		The <var>Add</var> statement adds a new occurrence of a field and/or value to a record.</p>

	====Syntax====		====Syntax====
	<p>		<p>
	The basic format of the ~~ADD~~ statement is:</p>		The basic format of the <var>Add</var> statement is:</p>
	<p class="syntax">~~ADD~~ <span class="term">fieldname</span> = {<span class="term">value</span> <span class="squareb">\|</span> (<span class="term">expression</span>)}		<p class="syntax">Add <span class="term">fieldname</span> = {<span class="term">value</span> <span class="squareb">\|</span> (<span class="term">expression</span>)} </p>
	</p>
	<p>		<p>
	Where:</p>		Where:</p>
Line 85:		Line 84:
	<li><span class="term">value</span> specifies the value you want to store.</li>		<li><span class="term">value</span> specifies the value you want to store.</li>

	<li>(<span class="term">expression</span>) can be used in place of value to specify the resolved value at the time of evaluation. (<span class="term">expression</span>) can be a function call, string concatenation, arithmetic operation, ~~User Language~~ construct, or Boolean expression. The expression must be enclosed in parentheses to invoke the expression compiler; otherwise the value will be treated as a literal string.</li>		<li>(<span class="term">expression</span>) can be used in place of value to specify the resolved value at the time of evaluation. (<span class="term">expression</span>) can be a function call, string concatenation, arithmetic operation, SOUL construct, or Boolean expression. The expression must be enclosed in parentheses to invoke the expression compiler; otherwise the value will be treated as a literal string.</li>
	</ul>		</ul>

Line 115:		Line 114:
	====Usage====		====Usage====
	<ul>		<ul>
	<li>The <var>~~ADD~~</var> statement places an additional occurrence of a field-value pair on the record.</li>		<li>The <var>Add</var> statement places an additional occurrence of a field-value pair on the record. </li>

	<li>You can use the <var>ADD</var> statement to add any field to a record except for a sort or hash key field. You can use this statement only within a <var>~~FOR EACH RECORD~~</var> loop.</li>		<li>You can use the <var>ADD</var> statement to add any field to a record except for a sort or hash key field. You can use this statement only within a <var>For Each Record</var> loop. </li>

	<li>The <var>~~ADD~~</var> statement is supported in remote file and scattered group contexts.</li>		<li>The <var>Add</var> statement is supported in remote file and scattered group contexts. </li>

	<li>To use the <var>~~ADD~~</var> statement with multiply occurring fields, see the [[Processing multiply occurring fields and field groups#ADD statement\|ADD statement for multiply occurring fields]]. </li>		<li>To use the <var>Add</var> statement with multiply occurring fields, see the [[Processing multiply occurring fields and field groups#ADD statement\|ADD statement for multiply occurring fields]]. </li>

	<li>To add a field whose value you do not explicitly specify, see [[#Using VALUE IN to reference a NOTE value\|Using VALUE IN to reference a NOTE value]], below. </li>		<li>To add a field whose value you do not explicitly specify, see [[#Using VALUE IN to reference a NOTE value\|Using VALUE IN to reference a NOTE value]], below. </li>

	<li>For Large Object data in non-[[FILEORG parameter\|FILEORG X'100']] files, a compiler error is issued for <var>~~ADD~~</var> (and <var>~~STORE~~</var>) statements if the context to the right of the equal sign (<tt>=</tt>) is not a <var>BUFFER</var> reference:		<li>For Large Object data in non-[[FILEORG parameter\|FILEORG X'100']] files, a compiler error is issued for <var>Add</var> (and <var>Store</var>) statements if the context to the right of the equal sign (<tt>=</tt>) is not a <var>BUFFER</var> reference:
	<p class="code">M204.0037: ~~INVALID SYNTAX~~		<p class="code">M204.0037: Invalid syntax
	</p></li>		</p></li>
	</ul>		</ul>

Admin: /* Change statement */ link repair

2018-04-25T21:00:58Z

Change statement: link repair

← Older revision		Revision as of 21:00, 25 April 2018
Line 137:		Line 137:
	<p>		<p>
	The basic format of the <var>Change</var> statement is: </p>		The basic format of the <var>Change</var> statement is: </p>
	{{Template:Change ~~non-lob-~~fieldname statement syntax}}		{{Template:Change fieldname statement syntax (basic)}}
	<p>		<p>
	Where:</p>		Where:</p>

JAL: /* Change statement */ add info re subscript, which was missing from syntax

2018-04-25T20:10:48Z

Change statement: add info re subscript, which was missing from syntax

← Older revision		Revision as of 20:10, 25 April 2018
Line 137:		Line 137:
	<p>		<p>
	The basic format of the <var>Change</var> statement is: </p>		The basic format of the <var>Change</var> statement is: </p>
	~~<p class="syntax">~~Change ~~<span class="term">~~fieldname~~</span> [<b></b>= <span class="term">value</span> \|(<span class="term">expression</span>)] To (<span class="term">newvalue</span> \|(<span class="term">expression</span>))~~		{{Template:Change non-lob-fieldname statement syntax}}
	~~</p>~~
	<p>		<p>
	Where:</p>		Where:</p>
Line 144:		Line 143:
	<li><var class="term">fieldname</var> specifies the name of the field to add to the record, or identify the field where the value is changed. </li>		<li><var class="term">fieldname</var> specifies the name of the field to add to the record, or identify the field where the value is changed. </li>

	<li><var class="term">value</var> is required only if the field has the <var>INVISIBLE</var> attribute. See the discussion on the [[Field attributes#INVISIBLE attribute\|INVISIBLE attribute]]. </li>		<li>(<var class="term">subscript</var>) specifies an ordinal number that is used to select a particular occurrence of a multiply occurring field. See the discussion in [[Processing multiply occurring fields and field groups#Subscripts\|Subscripts]]. </li>

			<li><var class="term">value</var> is required only if the field has the <var>INVISIBLE</var> attribute. See the discussion of the [[Field attributes#INVISIBLE attribute\|INVISIBLE attribute]]. </li>

	<li><var class="term">newvalue</var> specifies the value that overwrites the existing value for the field. </li>		<li><var class="term">newvalue</var> specifies the value that overwrites the existing value for the field. </li>

JAL: /* Change statement */ typo

2018-04-25T19:18:49Z

Change statement: typo

← Older revision		Revision as of 19:18, 25 April 2018
Line 137:		Line 137:
	<p>		<p>
	The basic format of the <var>Change</var> statement is: </p>		The basic format of the <var>Change</var> statement is: </p>
	<p class="syntax">Change<span class="term">fieldname</span> [<b></b>= <span class="term">value</span> \|(<span class="term">expression</span>)] To (<span class="term">newvalue</span> \|(<span class="term">expression</span>))		<p class="syntax">Change <span class="term">fieldname</span> [<b></b>= <span class="term">value</span> \|(<span class="term">expression</span>)] To (<span class="term">newvalue</span> \|(<span class="term">expression</span>))
	</p>		</p>
	<p>		<p>