CREATE command: Temporary group

From m204wiki
Revision as of 19:00, 20 October 2017 by JAL (talk | contribs) (add link)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Any user
Creates a Model 204 temporary file group


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


groupname The name of the temporary file group that is being created (1 to 8 characters). The group name cannot be FILE or GROUP, and it cannot start with CCA, SYS, OUT, TAPE, dollar sign ($), or percent sign (%).

The group name 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 ( / )
filename 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 Temporary group parameters, below.



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 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 you omit TEMP from the CREATE GROUP command, Model 204 assumes you are creating a temporary group.

Temporary group parameters

The CREATE GROUP REGION example above 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:

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 SOUL 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 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 allow for 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 more information, see multiple procedure files.

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

See also