CREATE PERM GROUP command: Difference between revisions
(→Syntax) |
(→Syntax) |
||
Line 98: | Line 98: | ||
<tr> <th><var>PRIVDEF</var></th> <td>Indicates the default privileges for public and semi-public groups. If not specified, default group privileges are set to X'3FFF' (all privileges). </td> </tr> | <tr> <th><var>PRIVDEF</var></th> <td>Indicates the default privileges for public and semi-public groups. If not specified, default group privileges are set to X'3FFF' (all privileges). </td> </tr> | ||
<tr> <th><var>PROCFILE</var></th> <td>Defines the group's procedure file. Multiple procedure files can be specified with PROCFILE = *, as explained in | <tr> <th><var>PROCFILE</var></th> <td>Defines the group's procedure file. Multiple procedure files can be specified with PROCFILE = *, as explained in [[CREATE command: Temporary group]]. | ||
<p>With scattered groups, PROCFILE must refer to a local file, and its value cannot be an asterisk (*). </p> | <p>With scattered groups, PROCFILE must refer to a local file, and its value cannot be an asterisk (*). </p> | ||
</td> </tr> | </td> </tr> |
Revision as of 22:25, 18 July 2013
Summary
- Privileges
- System manager
- Function
- Creates a Model 204 permanent file group
Syntax
CREATE PERM GROUP groupname FROM {filename [AT location] [(OPTIONAL) | (MANDATORY)]} ,... [PARAMETER parameter[=value] [PARAMETER parameter[=value]]... . . . END
Where:
groupname | is the name of the permanent 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 shown in the following table:
|
||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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, do not 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 | specifies Model 204 group parameters. Any number of PARAMETER statements can follow, and each can contain as many parameters in any order as fit on one input line. Valid permanent group parameters are described in the table below. All but PRIVATE, PUBLIC, and SEMIPUB must be followed by a value.
|
Syntax notes
Commas and equal signs are optional.
Example
CREATE PERM GROUP ACCOUNT FROM ACC1, - ACC2, ACC3, ACC4 *** M204.0825: READING GROUP PARAMETERS PARAMETER PROCFILE = ACC1, PRIVDEF = X'3FFF' END *** M204.0830: PERM GROUP CREATED
Usage notes
The CREATE PERM GROUP command creates a permanent file group from the files specified in the command. A permanent group is a group established by the system manager and maintained permanently in an external file (the CCAGRP file) until it is explicitly deleted. Before a permanent group can be created, the system manager must create the CCAGRP file in which the group definitions are stored. This is accomplished with the CREATEG command.
When it processes CREATE PERM GROUP, Model 204 ends any update unit in progress and begins a non-backoutable update unit. For more information about Model 204 update units, see the Model 204 File Manager's Guide.
Duplicate identifiers for a local file are detected when Model 204 tries to open the group. A Model 204 messages tells you the name of the file duplicates that result from using file synonyms. You cannot:
-
Specify multiple identifiers for the same file in a CREATE GROUP command: that is, you cannot include two synonyms for the same file.
-
Include a synonym and a remote file specification for the same file.