CREATE command: Temporary group: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
Line 7: Line 7:
</dl>
</dl>
==Syntax==
==Syntax==
<p class="syntax">CREATE TEMP GROUP <i>groupname</i>
<p class="syntax">CREATE TEMP GROUP <var class="term">groupname</var>
  FROM {<i>filename</i> [AT <i>location</i>]  
  FROM {<var class="term">filename</var> [AT <var class="term">location</var>]  
  [(<b>OPT</b>IONAL) | (<u><b>MAND</b>ATORY</u>)]} ,...
  [(<b>OPT</b>IONAL) | (<u><b>MAND</b>ATORY</u>)]} ,...
  [PARAMETER <i>parameter</i>[=value]  
  [PARAMETER <var class="term">parameter</var>[=<var class="term">value</var>]  
  [<i>,parameter</i>[=value]]...
  [,<var class="term">parameter</var>[=<var class="term">value</var>]]...
  .
  .
  .
  .
Line 22: Line 22:
<tr>
<tr>
<th>groupname</th>
<th>groupname</th>
<td> is the name of the temporary file group that is being created (1 to 8 characters). The group name cannot be FILE or GROUP and cannot start with CCA, SYS, OUT, TAPE, dollar sign ($), or percent sign (%). It can contain any alphanumeric characters except:
<td> is the name of the temporary file group that is being created (1 to 8 characters). The group name cannot be FILE or GROUP and cannot start with CCA, SYS, OUT, TAPE, dollar sign ($), or percent sign (%). It can contain any alphanumeric characters except those in the following table:
<table>
<table>
    
    
Line 54: Line 54:
<th>filename</th>
<th>filename</th>
<td> is the name of a <var class="product">Model&nbsp;204</var> file.
<td> is the name of a <var class="product">Model&nbsp;204</var> file.
<p>If you are specifying Parallel Query Option/204 remote files, filename must include a remote location (AT location) or be a defined file synonym. Also, you cannot specify multiple identifiers for the same file: that is, you cannot include two synonyms for the same file, and you cannot include a synonym and a remote file specification for the same file. </p>
<p>If you are specifying Parallel Query Option/204 remote files, <var class="term">filename</var> must include a remote location (AT <var class="term">location</var>) or be a defined file synonym. Also, you cannot specify multiple identifiers for the same file: that is, you cannot include two synonyms for the same file, and you cannot include a synonym and a remote file specification for the same file. </p>
</td>
</td>
</tr>
</tr>
Line 60: Line 60:
<tr>
<tr>
<th>location</th>
<th>location</th>
<td>, for PQO files, is the symbolic name (as many as eight characters) that refers to the location of the node on which the remote file resides. An unquoted equal sign (=) specifies that the file is local.</td>
<td>for PQO files, <var class="term">location</var> is the symbolic name (as many as eight characters) that refers to the location of the node on which the remote file resides. An unquoted equal sign (=) specifies that the file is local.</td>
</tr>
</tr>
   
   
Line 72: Line 72:
<tr>
<tr>
<th>parameter=value</th>
<th>parameter=value</th>
<td> specifies <var class="product">Model&nbsp;204</var> temporary group parameters. Multiple PARAMETER statements can follow, and each can contain as many parameters in any order that fits on one input line. Valid temporary group parameters are described in the table below.</td>
<td> specifies <var class="product">Model&nbsp;204</var> temporary group parameters. Multiple PARAMETER statements can follow, and each statement can contain as many parameters in any order as will fit on one input line. Valid temporary group parameters are described in the table below.</td>
</tr>
</tr>
   
   
</table>
</table>
==Example==
==Example==
<p class="code"><b>CREATE GROUP REGION FROM DELAWARE, -
<p class="code"><b>CREATE GROUP REGION FROM DELAWARE, -

Revision as of 22:35, 18 July 2013

Summary

Privileges
Any user
Function
Creates a Model 204 temporary file group

Syntax

CREATE TEMP GROUP groupname FROM {filename [AT location] [(OPTIONAL) | (MANDATORY)]} ,... [PARAMETER parameter[=value] [,parameter[=value]]... . . . END

Where:

groupname is the name of the temporary file group that is being created (1 to 8 characters). The group name cannot be FILE or GROUP and cannot start with CCA, SYS, OUT, TAPE, dollar sign ($), or percent sign (%). It can contain any alphanumeric characters except those in the following table:
Character name Keyboard symbol
Asterisk ( * )
Equal sign ( = )
Left parenthesis ( ( )
Minus sign ( - )
Plus sign ( + )
Right parenthesis ( ) )
Semicolon ( ; )
Single quote ( ' )
Slash ( / )
Space
filename is the name of a Model 204 file.

If you are specifying Parallel Query Option/204 remote files, filename must include a remote location (AT location) or be a defined file synonym. Also, you cannot specify multiple identifiers for the same file: that is, you cannot include two synonyms for the same file, and you cannot include a synonym and a remote file specification for the same file.

location for PQO files, location is the symbolic name (as many as eight characters) that refers to the location of the node on which the remote file resides. An unquoted equal sign (=) specifies that the file is local.
OPTIONAL or MANDATORY indicates whether PQO scattered group operations can proceed in the absence of this group member. The default is MANDATORY. Valid abbreviations are OPT and MAND.

You cannot open a group if a mandatory member is unavailable. Also, you cannot specify OPTIONAL for local files.

parameter=value specifies Model 204 temporary group parameters. Multiple PARAMETER statements can follow, and each statement can contain as many parameters in any order as will fit on one input line. Valid temporary group parameters are described in the table below.

Example

CREATE GROUP REGION FROM DELAWARE, - MARYLAND, VIRGINIA *** M204.0825: READING GROUP PARAMETERS PARAMETER PROCFILE = VIRGINIA END *** M204.0828: TEMP GROUP CREATED: REGION

Usage notes

The CREATE TEMP GROUP command creates a temporary file group from the Model 204 files specified in the command. A temporary group is a group established by a user for use during the current login session. A temporary group can be referenced only by the user who creates it.

The temporary group ceases to exist when the user logs out. If TEMP is omitted from the CREATE GROUP command, Model 204 assumes that the user is creating a temporary group.

The preceding example shows how group parameters can be specified. The Model 204 temporary group parameters that can be set in the CREATE command's parameter list are shown in the table below.

Parameters for CREATE TEMP GROUP
Parameter Defines...
UPDTFILE Group's update file.
PROCFILE Group's procedure file, or specifies that the group can contain multiple procedure files.
BLDGFT Whether to build an internal field table for this group. Can be YES or NO; YES is the default.

The UPDTFILE parameter defines the group's update file. When a User Language STORE RECORD statement is encountered and Model 204 cannot determine a file context, the record is stored in the group update file. If UPDTFILE is not specified, no update file is assigned. The $UPDATE function, described in the Model 204 User Language Manual, provides a convenient method for manipulating the update file.

The PROCFILE parameter defines the group's procedure file. All procedure-related commands and the INCLUDE statement operate on this file if no other file context is established. If this parameter is omitted, no procedure file is assigned. You can also use PROCFILE to specify multiple procedure files for a group. If a group contains multiple procedure files, then the INCLUDE statement searches the entire group for the procedure to be included. The search proceeds in order from the first file defined in the CREATE GROUP command to the last.

To specify multiple procedure files, specify PROCFILE = *, which indicates that any of the files in a group can contain procedures. This specification is optional; use it only if more than one file in the group contains procedures that you want to include.

For a discussion of multiple procedure files and application subsystem development, refer to the Model 204 User Language Manual.

The BLDGFT parameter directs Model 204 whether to maintain certain information about the group in an internal field table. The option you should specify depends upon how long you expect to use the group. If the group is only to satisfy a few short requests, specify NO. The default is YES.