DML statements in Parallel Query Option/204 - Revision history

JAL: mixed case for For Record Number

2018-04-27T18:00:29Z

mixed case for For Record Number

← Older revision		Revision as of 18:00, 27 April 2018
Line 40:		Line 40:

	====Retrieval conditions====		====Retrieval conditions====
	<p class="code">~~FIND~~$		<p class="code">Find$
	~~FILE~~$		File$
	~~LIST~~$		List$
	~~LOCATION~~$		Location$
	~~POINT~~$		Point$
	~~SFGE~~$		Sfge$
	~~SFL~~$		Sfl$
	</p>		</p>

Line 76:		Line 76:
	===Using field names in expressions===		===Using field names in expressions===
	<p>		<p>
	Fields in remote context can be used in the same ways as fields in local context including the ~~VALUE IN~~ phrase, which refers to a label on a ~~FOR EACH RECORD IN ORDER~~ statement. </p>		Fields in remote context can be used in the same ways as fields in local context including the <var>Value In</var> phrase, which refers to a label on a <var>For Each Record In Order</var> statement. </p>

	==Restricted commands and $functions==		==Restricted commands and $functions==

JAL: mixed case for For Record Number

2018-04-27T16:55:55Z

mixed case for For Record Number

← Older revision		Revision as of 16:55, 27 April 2018
Line 9:		Line 9:

	====Retrieval statements====		====Retrieval statements====
	<p class="code">[[Lists#Clearing a list\|~~CLEAR LIST~~]]		<p class="code">[[Lists#Clearing a list\|Clear List]]
	~~COMMIT RELEASE~~		Commit Release
	[[~~Processing_multiply_occurring_fields_and_field_groups~~#~~COUNT_OCCURRENCES_OF_statement\|~~COUNT OCCURRENCES OF]]		[[Processing multiply occurring fields and field groups#COUNT OCCURRENCES OF statement\|Count Occurrences Of]]
	[[~~Basic_SOUL_statements_and_commands~~#~~COUNT_RECORDS_IN~~.~~2FON_statement~~\|~~COUNT RECORDS~~]]		[[Basic SOUL statements and commands#COUNT RECORDS IN.2FON statement\|Count Records]]
	[[Lists#DECLARE LIST syntax\|~~DECLARE LIST~~]]		[[Lists#DECLARE LIST syntax\|Declare List]]
	[[~~Find_Records_statement~~\|~~FIND RECORDS~~]]		[[Find Records statement\|Find Records]]
	[[~~Value_loops~~#~~Using_value_loops~~\|~~FIND ALL RECORDS~~]]		[[Value loops#Using value loops\|Find All Records]]
	[[~~Value_loops~~#~~Find_All_Values_statement~~\|~~FIND ALL VALUES~~]]		[[Value loops#Find All Values statement\|Find All Values]]
	[[~~Basic_SOUL_statements_and_commands~~#~~FIND_AND_PRINT_COUNT_statement\|~~FIND AND PRINT COUNT]]		[[Basic SOUL statements and commands#FIND AND PRINT COUNT statement\|Find And Print Count]]
	[[~~Processing_multiply_occurring_fields_and_field_groups~~#~~FOR_EACH_OCCURRENCE_OF_loops\|~~FOR EACH OCCURRENCE]]		[[Processing multiply occurring fields and field groups#FOR EACH OCCURRENCE OF loops\|For Each occurrence]]
	[[~~Value_loops~~#~~Using_value_loops~~\|~~FOR EACH RECORD~~]]		[[Value loops#Using value loops\|For Each Record]]
	[[~~Value_loops~~#~~FOR_EACH_VALUE_statement\|~~FOR EACH VALUE]]		[[Value loops#FOR EACH VALUE statement\|For Each Value]]
	~~FOR~~ k ~~RECORDS~~		For <var class="term">k</var> Records
	~~FOR~~ k ~~VALUES~~		For <var class="term">k</var> Values
	[[~~FOR_RECORD_NUMBER_statement~~#~~FOR_RECORD_NUMBER_processing~~\|~~FOR RECORD NUMBER~~]]		[[For Record Number statement#For Record Number processing\|For Record Number]]
	~~NOTE~~ fieldname		Note <var class="term">fieldname</var>
	[[~~Open_and_OpenC_statements~~#~~Open_statement_and_OpenC_statement~~\|~~OPEN~~]]		[[Open and OpenC statements#Open statement and OpenC statement\|Open]]
	[[~~Open_and_OpenC_statements~~#~~Open_statement_and_OpenC_statement~~\|~~OPENC~~]]		[[Open and OpenC statements#Open statement and OpenC statement\|OpenC]]
	[[Lists#PLACE RECORD and REMOVE RECORD statements\|~~PLACE RECORD ON LIST~~]]		[[Lists#PLACE RECORD and REMOVE RECORD statements\|Place Record On List]]
	~~PLACE RECORDS ON LIST~~		Place Records On List
	[[~~Print_All_Information_statement~~#~~PRINT_ALL_INFORMATION_~~.~~28or_PAI~~.~~29_statement~~\|~~PRINT ALL INFORMATION~~]]		[[Print All Information statement#PRINT ALL INFORMATION .28or PAI.29 statement\|Print All information]]
	~~RELEASE ALL RECORDS~~		Release All Records
	~~RELEASE RECORDS~~		Release Records
	[[Lists#PLACE RECORD and REMOVE RECORD statements\|~~REMOVE RECORD FROM LIST~~]]		[[Lists#PLACE RECORD and REMOVE RECORD statements\|Remove Record From List]]
	~~REMOVE RECORDS FROM LIST~~		Remove Records From List
	[[Sorting#~~Sorting_by_record_key~~\|~~SORT RECORD KEYS~~]]		[[Sorting#Sorting by record key\|Sort Record keys]]
	[[Sorting#~~SORT_RECORDS_statement\|~~SORT RECORDS]]		[[Sorting#SORT RECORDS statement\|Sort Records]]
	~~SORT VALUES~~		Sort Values
	</p>		</p>

Line 50:		Line 50:

	====Update statements====		====Update statements====
	<p class="code">~~ADD~~		<p class="code">Add
	~~BACKOUT~~		Backout
	~~CHANGE~~		Change
	~~COMMIT~~		Commit
	~~DELETE~~		Delete
	~~DELETE EACH~~		Delete Each
	~~DELETE RECORD~~		Delete Record
	~~DELETE RECORDS~~		Delete Records
	~~FILE RECORDS~~		File Records
	~~INSERT~~		Insert
	~~STORE RECORD~~		Store Record
	~~UPDATE RECORD~~		Update Record
	</p>		</p>

ELowell: /* Retrieval statements */

2016-12-29T01:04:55Z

Retrieval statements

← Older revision		Revision as of 01:04, 29 December 2016
Line 12:		Line 12:
	COMMIT RELEASE		COMMIT RELEASE
	[[Processing_multiply_occurring_fields_and_field_groups#COUNT_OCCURRENCES_OF_statement\|COUNT OCCURRENCES OF]]		[[Processing_multiply_occurring_fields_and_field_groups#COUNT_OCCURRENCES_OF_statement\|COUNT OCCURRENCES OF]]
	COUNT RECORDS		[[Basic_SOUL_statements_and_commands#COUNT_RECORDS_IN.2FON_statement\|COUNT RECORDS]]
	[[Lists#DECLARE LIST syntax\|DECLARE LIST]]		[[Lists#DECLARE LIST syntax\|DECLARE LIST]]
	FIND RECORDS		[[Find_Records_statement\|FIND RECORDS]]
	[[Value_loops#Using_value_loops\|FIND ALL RECORDS]]		[[Value_loops#Using_value_loops\|FIND ALL RECORDS]]
	[[Value_loops#Find_All_Values_statement\|FIND ALL VALUES]]		[[Value_loops#Find_All_Values_statement\|FIND ALL VALUES]]
	FIND AND PRINT COUNT		[[Basic_SOUL_statements_and_commands#FIND_AND_PRINT_COUNT_statement\|FIND AND PRINT COUNT]]
	[[Processing_multiply_occurring_fields_and_field_groups#FOR_EACH_OCCURRENCE_OF_loops\|FOR EACH OCCURRENCE]]		[[Processing_multiply_occurring_fields_and_field_groups#FOR_EACH_OCCURRENCE_OF_loops\|FOR EACH OCCURRENCE]]
	[[Value_loops#Using_value_loops\|FOR EACH RECORD]]		[[Value_loops#Using_value_loops\|FOR EACH RECORD]]
Line 23:		Line 23:
	FOR k RECORDS		FOR k RECORDS
	FOR k VALUES		FOR k VALUES
	FOR RECORD NUMBER		[[FOR_RECORD_NUMBER_statement#FOR_RECORD_NUMBER_processing\|FOR RECORD NUMBER]]
	NOTE fieldname		NOTE fieldname
	[[Open_and_OpenC_statements#Open_statement_and_OpenC_statement\|OPEN]]		[[Open_and_OpenC_statements#Open_statement_and_OpenC_statement\|OPEN]]

ELowell: /* Retrieval statements */

2016-12-28T23:19:41Z

Retrieval statements

← Older revision		Revision as of 23:19, 28 December 2016
Line 25:		Line 25:
	FOR RECORD NUMBER		FOR RECORD NUMBER
	NOTE fieldname		NOTE fieldname
	OPEN		[[Open_and_OpenC_statements#Open_statement_and_OpenC_statement\|OPEN]]
	OPENC		[[Open_and_OpenC_statements#Open_statement_and_OpenC_statement\|OPENC]]
	[[Lists#PLACE RECORD and REMOVE RECORD statements\|PLACE RECORD ON LIST]]		[[Lists#PLACE RECORD and REMOVE RECORD statements\|PLACE RECORD ON LIST]]
	PLACE RECORDS ON LIST		PLACE RECORDS ON LIST
	PRINT ALL INFORMATION		[[Print_All_Information_statement#PRINT_ALL_INFORMATION_.28or_PAI.29_statement\|PRINT ALL INFORMATION]]
	RELEASE ALL RECORDS		RELEASE ALL RECORDS
	RELEASE RECORDS		RELEASE RECORDS

ELowell: /* Retrieval statements */

2016-12-28T22:13:07Z

Retrieval statements

← Older revision		Revision as of 22:13, 28 December 2016
Line 11:		Line 11:
	<p class="code">[[Lists#Clearing a list\|CLEAR LIST]]		<p class="code">[[Lists#Clearing a list\|CLEAR LIST]]
	COMMIT RELEASE		COMMIT RELEASE
	COUNT OCCURRENCES OF		[[Processing_multiply_occurring_fields_and_field_groups#COUNT_OCCURRENCES_OF_statement\|COUNT OCCURRENCES OF]]
	COUNT RECORDS		COUNT RECORDS
	[[Lists#DECLARE LIST syntax\|DECLARE LIST]]		[[Lists#DECLARE LIST syntax\|DECLARE LIST]]
Line 18:		Line 18:
	[[Value_loops#Find_All_Values_statement\|FIND ALL VALUES]]		[[Value_loops#Find_All_Values_statement\|FIND ALL VALUES]]
	FIND AND PRINT COUNT		FIND AND PRINT COUNT
	FOR EACH OCCURRENCE		[[Processing_multiply_occurring_fields_and_field_groups#FOR_EACH_OCCURRENCE_OF_loops\|FOR EACH OCCURRENCE]]
	[[Value_loops#Using_value_loops\|FOR EACH RECORD]]		[[Value_loops#Using_value_loops\|FOR EACH RECORD]]
	[[Value_loops#FOR_EACH_VALUE_statement\|FOR EACH VALUE]]		[[Value_loops#FOR_EACH_VALUE_statement\|FOR EACH VALUE]]
Line 34:		Line 34:
	[[Lists#PLACE RECORD and REMOVE RECORD statements\|REMOVE RECORD FROM LIST]]		[[Lists#PLACE RECORD and REMOVE RECORD statements\|REMOVE RECORD FROM LIST]]
	REMOVE RECORDS FROM LIST		REMOVE RECORDS FROM LIST
	SORT RECORD KEYS		[[Sorting#Sorting_by_record_key\|SORT RECORD KEYS]]
	SORT RECORDS		[[Sorting#SORT_RECORDS_statement\|SORT RECORDS]]
	SORT VALUES		SORT VALUES
	</p>		</p>

ELowell: /* Restricted Model 204 commands */

2016-12-28T21:56:00Z

Restricted Model 204 commands

← Older revision		Revision as of 21:56, 28 December 2016
Line 85:		Line 85:
	<p>		<p>
	Some of the <var class="product">Model 204</var> commands that specify a file name, or that operate on a default file or on a file specified in an IN clause, are not supported in remote context for Parallel Query Option/204 processing. </p>		Some of the <var class="product">Model 204</var> commands that specify a file name, or that operate on a default file or on a file specified in an IN clause, are not supported in remote context for Parallel Query Option/204 processing. </p>
			<p>See [[Files, groups, and reference context#Using Model 204 file and group commands\|Using Model 204 file and group commands]] for a description of the commands that can be used to reference files in remote context.</p>
	<p>		<p>
	The following commands cannot be used in reference to a remote file. See [[Files, groups, and reference context#Using Model 204 file and group commands\|Using Model 204 file and group commands]] for a description of the commands that can be used to reference files in remote context:</p>		The following commands cannot be used in reference to a remote file:</p>
	<p class="code">ASSIGN (specifying a procedure alias)		<p class="code">ASSIGN (specifying a procedure alias)
	BROADCAST FILE		BROADCAST FILE
Line 122:		Line 123:
	TRANSFORM		TRANSFORM
	Z</p>		Z</p>

	===Restricted $functions===		===Restricted $functions===
	<p>		<p>

ELowell at 21:51, 28 December 2016

2016-12-28T21:51:56Z

← Older revision		Revision as of 21:51, 28 December 2016
Line 15:		Line 15:
	[[Lists#DECLARE LIST syntax\|DECLARE LIST]]		[[Lists#DECLARE LIST syntax\|DECLARE LIST]]
	FIND RECORDS		FIND RECORDS
	FIND ALL RECORDS		[[Value_loops#Using_value_loops\|FIND ALL RECORDS]]
	FIND ALL VALUES		[[Value_loops#Find_All_Values_statement\|FIND ALL VALUES]]
	FIND AND PRINT COUNT		FIND AND PRINT COUNT
	FOR EACH OCCURRENCE		FOR EACH OCCURRENCE
	FOR EACH RECORD		[[Value_loops#Using_value_loops\|FOR EACH RECORD]]
	FOR EACH VALUE		[[Value_loops#FOR_EACH_VALUE_statement\|FOR EACH VALUE]]
	FOR k RECORDS		FOR k RECORDS
	FOR k VALUES		FOR k VALUES

ELowell: /* Retrieval statements */

2016-02-20T00:07:13Z

Retrieval statements

← Older revision		Revision as of 00:07, 20 February 2016
Line 13:		Line 13:
	COUNT OCCURRENCES OF		COUNT OCCURRENCES OF
	COUNT RECORDS		COUNT RECORDS
	DECLARE LIST		[[Lists#DECLARE LIST syntax\|DECLARE LIST]]
	FIND RECORDS		FIND RECORDS
	FIND ALL RECORDS		FIND ALL RECORDS
Line 27:		Line 27:
	OPEN		OPEN
	OPENC		OPENC
	PLACE RECORD ON LIST		[[Lists#PLACE RECORD and REMOVE RECORD statements\|PLACE RECORD ON LIST]]
	PLACE RECORDS ON LIST		PLACE RECORDS ON LIST
	PRINT ALL INFORMATION		PRINT ALL INFORMATION
	RELEASE ALL RECORDS		RELEASE ALL RECORDS
	RELEASE RECORDS		RELEASE RECORDS
	REMOVE RECORD FROM LIST		[[Lists#PLACE RECORD and REMOVE RECORD statements\|REMOVE RECORD FROM LIST]]
	REMOVE RECORDS FROM LIST		REMOVE RECORDS FROM LIST
	SORT RECORD KEYS		SORT RECORD KEYS

ELowell: /* Retrieval statements */

2016-02-19T23:33:33Z

Retrieval statements

← Older revision		Revision as of 23:33, 19 February 2016
Line 9:		Line 9:

	====Retrieval statements====		====Retrieval statements====
	<p class="code">CLEAR LIST		<p class="code">[[Lists#Clearing a list\|CLEAR LIST]]
	COMMIT RELEASE		COMMIT RELEASE
	COUNT OCCURRENCES OF		COUNT OCCURRENCES OF
Line 38:		Line 38:
	SORT VALUES		SORT VALUES
	</p>		</p>

	====Retrieval conditions====		====Retrieval conditions====
	<p class="code">FIND$		<p class="code">FIND$

JAL at 20:22, 17 January 2014

2014-01-17T20:22:50Z

← Older revision		Revision as of 20:22, 17 January 2014
Line 1:		Line 1:
	===Parallel Query Option/204 DML===
	<p>Parallel Query Option/204 data manipulation language (DML) consists of most, but not all, User Language statements and conditions. This ~~chapter~~ lists the statements and conditions that comprise Parallel Query Option/204 DML, and discusses certain restrictions on the use of some User Language commands, statements, and functions.</p>		==Parallel Query Option/204 DML==
	<p>Listed below, in separate sections, are the Parallel Query Option/204 retrieval statements, retrieval conditions, and update statements. A discussion of IN clauses and field names in DML statements follows the listings.</p>		<p>
	====DML statements and retrieval conditions====		Parallel Query Option/204 data manipulation language (DML) consists of most, but not all, User Language statements and conditions. This page lists the statements and conditions that comprise Parallel Query Option/204 DML, and discusses certain restrictions on the use of some User Language commands, statements, and functions.</p>
	~~<b>~~Retrieval statements~~</b>~~		<p>
	<p class="code">CLEAR LIST		Listed below, in separate sections, are the Parallel Query Option/204 retrieval statements, retrieval conditions, and update statements. A discussion of IN clauses and field names in DML statements follows the listings.</p>
	COMMIT RELEASE
	COUNT OCCURRENCES OF		===DML statements and retrieval conditions===
	COUNT RECORDS
			====Retrieval statements====
			<p class="code">CLEAR LIST
			COMMIT RELEASE
			COUNT OCCURRENCES OF
			COUNT RECORDS
	DECLARE LIST		DECLARE LIST
	FIND RECORDS		FIND RECORDS
	FIND ALL RECORDS		FIND ALL RECORDS
	FIND ALL VALUES		FIND ALL VALUES
	FIND AND PRINT COUNT		FIND AND PRINT COUNT
	FOR EACH OCCURRENCE		FOR EACH OCCURRENCE
	FOR EACH RECORD		FOR EACH RECORD
	FOR EACH VALUE		FOR EACH VALUE
	FOR k RECORDS		FOR k RECORDS
	FOR k VALUES		FOR k VALUES
	FOR RECORD NUMBER		FOR RECORD NUMBER
	NOTE fieldname		NOTE fieldname
	OPEN		OPEN
	OPENC		OPENC
	PLACE RECORD ON LIST		PLACE RECORD ON LIST
	PLACE RECORDS ON LIST		PLACE RECORDS ON LIST
	PRINT ALL INFORMATION		PRINT ALL INFORMATION
	RELEASE ALL RECORDS		RELEASE ALL RECORDS
	RELEASE RECORDS		RELEASE RECORDS
	REMOVE RECORD FROM LIST		REMOVE RECORD FROM LIST
	REMOVE RECORDS FROM LIST		REMOVE RECORDS FROM LIST
	SORT RECORD KEYS		SORT RECORD KEYS
	SORT RECORDS		SORT RECORDS
	SORT VALUES		SORT VALUES
	</p>		</p>
	~~<b>~~Retrieval conditions~~</b>~~
			====Retrieval conditions====
	<p class="code">FIND$		<p class="code">FIND$
	FILE$		FILE$
Line 40:		Line 46:
	POINT$		POINT$
	SFGE$		SFGE$
	SFL$		SFL$
	</p>		</p>
	~~<b>~~Update statements~~</b>~~
			====Update statements====
	<p class="code">ADD		<p class="code">ADD
	BACKOUT		BACKOUT
Line 56:		Line 63:
	UPDATE RECORD		UPDATE RECORD
	</p>		</p>
	====Using IN clauses====
	<p>A remote file specification (using either the AT clause or a file synonym) is syntactically valid in the IN FILE clause of supported DML statements in remote context. </p>		===Using IN clauses===
	<p>Also, you can use the following IN clause variations to refer to a remote file if you are in scattered group context: </p>		<p>
	<p class="code">IN GROUP groupname MEMBER		A remote file specification (using either the AT clause or a file synonym) is syntactically valid in the IN FILE clause of supported DML statements in remote context. </p>
	IN $CURFILE		<p>
	IN $UPDATE		Also, you can use the following IN clause variations to refer to a remote file if you are in scattered group context: </p>
			<p class="code">IN GROUP <i>groupname</i> MEMBER
			IN $CURFILE
			IN $UPDATE
	</p>		</p>
	====Using field names in expressions====
	<p>Fields in remote context can be used in the same ways as fields in local context including the VALUE IN phrase, which refers to a label on a FOR EACH RECORD IN ORDER statement. </p>		===Using field names in expressions===
	===Restricted commands and $functions===		<p>
	<p>The <var class="product">Model 204</var> commands, User Language statements, and $functions that are not supported in remote context for Parallel Query Option/204 processing are listed in this section.</p>		Fields in remote context can be used in the same ways as fields in local context including the VALUE IN phrase, which refers to a label on a FOR EACH RECORD IN ORDER statement. </p>
	====Restricted Model 204 commands====
	<p>Some of the <var class="product">Model 204</var> commands that specify a file name, or that operate on a default file or on a file specified in an IN clause, are not supported in remote context for Parallel Query Option/204 processing. </p>		==Restricted commands and $functions==
	<p>The following commands cannot be used in reference to a remote file. See [[Files, groups, and reference context#Using Model 204 file and group commands\|Using Model 204 file and group commands]] for a description of the commands that can be used to reference files in remote context:</p>		<p>
	<p>ASSIGN (specifying a procedure alias)		The <var class="product">Model 204</var> commands, User Language statements, and $functions that are not supported in remote context for Parallel Query Option/204 processing are listed in this section.</p>

			===Restricted Model 204 commands===
			<p>
			Some of the <var class="product">Model 204</var> commands that specify a file name, or that operate on a default file or on a file specified in an IN clause, are not supported in remote context for Parallel Query Option/204 processing. </p>
			<p>
			The following commands cannot be used in reference to a remote file. See [[Files, groups, and reference context#Using Model 204 file and group commands\|Using Model 204 file and group commands]] for a description of the commands that can be used to reference files in remote context:</p>
			<p class="code">ASSIGN (specifying a procedure alias)
	BROADCAST FILE		BROADCAST FILE
	CREATE FILE		CREATE FILE
Line 105:		Line 122:
	TRANSFORM		TRANSFORM
	Z</p>		Z</p>
	====Restricted $functions====
	<p>The following $functions cannot be used in reference to a remote file:</p>		===Restricted $functions===
	<p>$LSTPROC		<p>
			The following $functions cannot be used in reference to a remote file:</p>
			<p class="code">$LSTPROC
	$RDPROC</p>		$RDPROC</p>
	<p>If either of these $functions is used in reference to a remote file, <var class="product">Model 204</var> displays an error message. </p>		<p>
	~~<p> </p>~~		If either of these $functions is used in reference to a remote file, <var class="product">Model 204</var> displays an error message. </p>

	[[Category:SOUL]]		[[Category:SOUL]]