DML statements in Parallel Query Option/204: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (mixed case for For Record Number)
 
(10 intermediate revisions by 2 users not shown)
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  
DECLARE LIST
====Retrieval statements====
FIND RECORDS
<p class="code">[[Lists#Clearing a list|Clear List]]
FIND ALL RECORDS
Commit Release
FIND ALL VALUES
[[Processing multiply occurring fields and field groups#COUNT OCCURRENCES OF statement|Count Occurrences Of]]
FIND AND PRINT COUNT  
[[Basic SOUL statements and commands#COUNT RECORDS IN.2FON statement|Count Records]]
FOR EACH OCCURRENCE  
[[Lists#DECLARE LIST syntax|Declare List]]
FOR EACH RECORD
[[Find Records statement|Find Records]]
FOR EACH VALUE
[[Value loops#Using value loops|Find All Records]]
FOR k RECORDS
[[Value loops#Find All Values statement|Find All Values]]
FOR k VALUES
[[Basic SOUL statements and commands#FIND AND PRINT COUNT statement|Find And Print Count]]
FOR RECORD NUMBER
[[Processing multiply occurring fields and field groups#FOR EACH OCCURRENCE OF loops|For Each occurrence]]
NOTE fieldname  
[[Value loops#Using value loops|For Each Record]]
OPEN
[[Value loops#FOR EACH VALUE statement|For Each Value]]
OPENC
For <var class="term">k</var> Records
PLACE RECORD ON LIST
For <var class="term">k</var> Values
PLACE RECORDS ON LIST
[[For Record Number statement#For Record Number processing|For Record Number]]
PRINT ALL INFORMATION
Note <var class="term">fieldname</var>
RELEASE ALL RECORDS
[[Open and OpenC statements#Open statement and OpenC statement|Open]]
RELEASE RECORDS
[[Open and OpenC statements#Open statement and OpenC statement|OpenC]]
REMOVE RECORD FROM LIST 
[[Lists#PLACE RECORD and REMOVE RECORD statements|Place Record On List]]
REMOVE RECORDS FROM LIST 
Place Records On List
SORT RECORD KEYS 
[[Print All Information statement#PRINT ALL INFORMATION .28or PAI.29 statement|Print All information]]
SORT RECORDS
Release All Records
SORT VALUES
Release Records
[[Lists#PLACE RECORD and REMOVE RECORD statements|Remove Record From List]]
Remove Records From List
[[Sorting#Sorting by record key|Sort Record keys]]
[[Sorting#SORT RECORDS statement|Sort Records]]
Sort Values
</p>
</p>
<b>Retrieval conditions</b>
 
<p class="code">FIND$
====Retrieval conditions====
FILE$
<p class="code">Find$
LIST$
File$
LOCATION$
List$
POINT$
Location$
SFGE$
Point$
SFL$  
Sfge$
Sfl$
</p>
</p>
<b>Update statements</b>
<p class="code">ADD
====Update statements====
BACKOUT
<p class="code">Add
CHANGE
Backout
COMMIT
Change
DELETE
Commit
DELETE EACH
Delete
DELETE RECORD
Delete Each
DELETE RECORDS
Delete Record
FILE RECORDS
Delete Records
INSERT
File Records
STORE RECORD
Insert
UPDATE RECORD
Store 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&nbsp;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 <var>Value In</var> phrase, which refers to a label on a <var>For Each Record In Order</var> statement.    </p>
====Restricted Model 204 commands====
<p>Some of the <var class="product">Model&nbsp;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&nbsp;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&nbsp;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>
The following commands cannot be used in reference to a remote file:</p>
<p class="code">ASSIGN (specifying a procedure alias)
BROADCAST FILE
BROADCAST FILE
CREATE FILE
CREATE FILE
Line 105: Line 123:
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&nbsp;204</var> displays an error message. </p>
<p>
<p>&nbsp;</p>
If either of these $functions is used in reference to a remote file, <var class="product">Model&nbsp;204</var> displays an error message. </p>
[[Category:SOUL]]
[[Category:SOUL]]

Latest revision as of 18:00, 27 April 2018

Parallel Query Option/204 DML

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.

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.

DML statements and retrieval conditions

Retrieval statements

Clear List Commit Release Count Occurrences Of Count Records Declare List Find Records Find All Records Find All Values Find And Print Count For Each occurrence For Each Record For Each Value For k Records For k Values For Record Number Note fieldname Open OpenC Place Record On List Place Records On List Print All information Release All Records Release Records Remove Record From List Remove Records From List Sort Record keys Sort Records Sort Values

Retrieval conditions

Find$ File$ List$ Location$ Point$ Sfge$ Sfl$

Update statements

Add Backout Change Commit Delete Delete Each Delete Record Delete Records File Records Insert Store Record Update Record

Using IN clauses

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.

Also, you can use the following IN clause variations to refer to a remote file if you are in scattered group context:

IN GROUP groupname MEMBER IN $CURFILE IN $UPDATE

Using field names in expressions

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.

Restricted commands and $functions

The Model 204 commands, User Language statements, and $functions that are not supported in remote context for Parallel Query Option/204 processing are listed in this section.

Restricted Model 204 commands

Some of the Model 204 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.

See Using Model 204 file and group commands for a description of the commands that can be used to reference files in remote context.

The following commands cannot be used in reference to a remote file:

ASSIGN (specifying a procedure alias) BROADCAST FILE CREATE FILE DEASSIGN DECREASE DEFINE FIELD DELETE FIELD DELETE PROCEDURE DESECURE DESECURE PROCEDURE DISPLAY FILE DISPLAY LIST DISPLAY PROCEDURE DUMP EDIT ENQCTL FILELOAD FLOD INCLUDE INCREASE INITIALIZE PROCEDURE REDEFINE FIELD REGENERATE RENAME FIELD RENAME PROCEDURE REORGANIZE RESET (file parameters) RESTORE SECURE SECURE PROCEDURE TABLEB TABLEC TRANSFORM Z

Restricted $functions

The following $functions cannot be used in reference to a remote file:

$LSTPROC $RDPROC

If either of these $functions is used in reference to a remote file, Model 204 displays an error message.