CREATE PERM GROUP command - Revision history

JDamon: /* Syntax */

2025-01-17T02:40:30Z

Syntax

← Older revision		Revision as of 02:40, 17 January 2025
Line 144:		Line 144:
	<tr>		<tr>
	<th><var>UPDTFILE</var></th>		<th><var>UPDTFILE</var></th>
	<td>Defines the group's update file.		<td>Defines the group's update file for the STORE RECORD statement.

			<ul>
			<li>When a SOUL <var>Store Record</var> statement is encountered in a group context, and <var class="product">Model 204</var> cannot determine a file context, the record is stored in the group-update file. If <var>UPDTFILE</var> is not specified, no update file is assigned and any attempt to issue a STORE RECORD statement will fail with:
			<p class="code">M204.0203: "Store" requires update file</p code>
			In that case, use the "IN FILE" or 'IN MEMBER" clause with STORE RECORD:
			<p class="code">IN FILE filename STORE RECORD
			IN GROUP groupname MEMBER %membername STORE RECORD
			</p code>

			The [[$Update]] function also provides a convenient method for manipulating the update file. </li>

	<p>If used in PQO, <var>UPDTFILE</var> can refer to either local or remote files. If the update file you are naming is a remote file, you can include its remote file specification (AT <var class="term">location</var>). </p>		<p>If used in PQO, <var>UPDTFILE</var> can refer to either local or remote files. If the update file you are naming is a remote file, you can include its remote file specification (AT <var class="term">location</var>). </p>
	</td> </tr>		</td> </tr>

Dme: Dme moved page CREATE command: Permanent group to CREATE PERM GROUP command

2019-11-06T19:13:18Z

Dme moved page CREATE command: Permanent group to CREATE PERM GROUP command

← Older revision	Revision as of 19:13, 6 November 2019
(No difference)

DCameron: /* Usage notes */

2019-02-11T15:25:34Z

Usage notes

← Older revision		Revision as of 15:25, 11 February 2019
Line 169:		Line 169:
	==Usage notes==		==Usage notes==
	<ul>		<ul>
	<li>The <var>CREATE PERM GROUP</var> 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 [[Storing_and_using_file_group_definitions_(CCAGRP)\|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 <var>CREATEG</var> command.</li>		<li>The <var>CREATE PERM GROUP</var> 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 [[Storing_and_using_file_group_definitions_(CCAGRP)\|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 <var>[[CREATEG_command\|CREATEG]]</var> command.</li>

	<li>When it processes <var>CREATE PERM GROUP</var>, <var class="product">Model 204</var> ends any update unit in progress and begins a [[File integrity and recovery#Model 204 update units\|non-backoutable update unit]]. </li>		<li>When it processes <var>CREATE PERM GROUP</var>, <var class="product">Model 204</var> ends any update unit in progress and begins a [[File integrity and recovery#Model 204 update units\|non-backoutable update unit]]. </li>

DCameron: /* Usage notes */

2019-02-11T15:24:37Z

Usage notes

← Older revision		Revision as of 15:24, 11 February 2019
Line 169:		Line 169:
	==Usage notes==		==Usage notes==
	<ul>		<ul>
	<li>The <var>CREATE PERM GROUP</var> 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 <var>CREATEG</var> command.</li>		<li>The <var>CREATE PERM GROUP</var> 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 [[Storing_and_using_file_group_definitions_(CCAGRP)\|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 <var>CREATEG</var> command.</li>

	<li>When it processes <var>CREATE PERM GROUP</var>, <var class="product">Model 204</var> ends any update unit in progress and begins a [[File integrity and recovery#Model 204 update units\|non-backoutable update unit]]. </li>		<li>When it processes <var>CREATE PERM GROUP</var>, <var class="product">Model 204</var> ends any update unit in progress and begins a [[File integrity and recovery#Model 204 update units\|non-backoutable update unit]]. </li>

DCameron: /* Summary */

2019-02-11T15:21:44Z

Summary

← Older revision		Revision as of 15:21, 11 February 2019
Line 4:		Line 4:
	<dd>System manager		<dd>System manager
	<dt>Function		<dt>Function
	<dd>Creates a <var class="product">Model 204</var> permanent file group		<dd>Creates a <var class="product">Model 204</var> permanent [[Files,_groups,_and_reference_context#File_groups\|file group]]
	</dl>		</dl>

JAL: add link

2017-10-20T19:00:49Z

add link

← Older revision		Revision as of 19:00, 20 October 2017
Line 182:		Line 182:
	<p>Include a synonym and a remote file specification for the same file.</p></li>		<p>Include a synonym and a remote file specification for the same file.</p></li>
	</ul></li>		</ul></li>
			</ul>

			==See also==
			<ul>
			<li>[[CREATE command: Temporary group]] </li>
	</ul>		</ul>

	[[Category: System manager commands]]		[[Category: System manager commands]]
	[[Category:Commands]]		[[Category:Commands]]

JAL: minor formatting

2017-08-25T15:53:43Z

minor formatting

← Older revision		Revision as of 15:53, 25 August 2017
Line 6:		Line 6:
	<dd>Creates a <var class="product">Model 204</var> permanent file group		<dd>Creates a <var class="product">Model 204</var> permanent file group
	</dl>		</dl>

	==Syntax==		==Syntax==
	<p class="syntax">CREATE PERM GROUP <var class="term">groupname</var>		<p class="syntax">CREATE PERM GROUP <var class="term">groupname</var>
Line 83:		Line 84:
	<tr class="head"> <th>Parameter</th> <th>Meaning</th> </tr>		<tr class="head"> <th>Parameter</th> <th>Meaning</th> </tr>

	<tr> <th><var>ADDLVL</var></th>		<tr>
			<th><var>ADDLVL</var></th>
	<td>Identifies the <var>ADD</var> field level security access level for the files making up the group. The default is 0. </td> </tr>		<td>Identifies the <var>ADD</var> field level security access level for the files making up the group. The default is 0. </td> </tr>

	<tr> <th><var>BLDGFT </var></th>		<tr>
			<th><var>BLDGFT </var></th>
	<td>Indicates whether to build an internal field table for this group. Can be <code>YES</code> (default) or <code>NO</code>.		<td>Indicates whether to build an internal field table for this group. Can be <code>YES</code> (default) or <code>NO</code>.
	<p>		<p>
	<var>BLDGFT</var> is ignored for groups that include remote members.</p></td> </tr>		<var>BLDGFT</var> is ignored for groups that include remote members.</p></td> </tr>

	<tr> <th><var>MAXFAIL</var></th> <td>For scattered groups (PQO), the maximum number of optional members that can be unavailable. If more than <var>MAXFAIL</var> files are unavailable, the group fails to open or operations on the group are aborted.		<tr>
	<p>The value of <var>MAXFAIL</var> must be one of the following: </p>		<th><var>MAXFAIL</var></th> <td>For scattered groups (PQO), the maximum number of optional members that can be unavailable. If more than <var>MAXFAIL</var> files are unavailable, the group fails to open or operations on the group are aborted.
			<p>
			The value of <var>MAXFAIL</var> must be one of the following: </p>
	<ul>		<ul>
	<li>An integer between one and the number of optional group members. </li>		<li>An integer between one and the number of optional group members. </li>
Line 102:		Line 107:
	</td> </tr>		</td> </tr>

	<tr> <th><var>PCLASSDF</var></th>		<tr>
			<th><var>PCLASSDF</var></th>
	<td>Identifies the default user class with respect to the procedures defined for a permanent group. </td> </tr>		<td>Identifies the default user class with respect to the procedures defined for a permanent group. </td> </tr>

	<tr> <th><var>PRIVATE</var></th>		<tr>
			<th><var>PRIVATE</var></th>
	<td>Indicates that users are asked for a group password when they open the group. The password entered must be valid to open the group. </td> </tr>		<td>Indicates that users are asked for a group password when they open the group. The password entered must be valid to open the group. </td> </tr>

	<tr> <th><var>PRIVDEF</var></th>		<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>		<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 id="PROCFILE"><var>PROCFILE</var></th>		<tr>
			<th id="PROCFILE"><var>PROCFILE</var></th>
	<td>Defines the group's procedure file. Multiple procedure files can be specified with <code>PROCFILE = *</code>, as explained in [[CREATE command: Temporary group#Temporary group parameters\|Temporary group parameters]].		<td>Defines the group's procedure file. Multiple procedure files can be specified with <code>PROCFILE = *</code>, as explained in [[CREATE command: Temporary group#Temporary group parameters\|Temporary group parameters]].
	<p>		<p>
Line 117:		Line 126:
	</td> </tr>		</td> </tr>

	<tr> <th><var>PUBLIC</var></th>		<tr>
			<th><var>PUBLIC</var></th>
	<td>Indicates that users are not asked for a group password when they open the group and are automatically given default group privileges. If none of the parameters <var>PUBLIC</var>, <var>SEMIPUB</var>, or <var>PRIVATE</var> is specified, <var>PUBLIC</var> is the default. </td> </tr>		<td>Indicates that users are not asked for a group password when they open the group and are automatically given default group privileges. If none of the parameters <var>PUBLIC</var>, <var>SEMIPUB</var>, or <var>PRIVATE</var> is specified, <var>PUBLIC</var> is the default. </td> </tr>

	<tr> <th><var>READLVL</var></th>		<tr>
			<th><var>READLVL</var></th>
	<td>Identifies the <var>READ</var> field level security access level for the files making up the group. The default is 0. </td> </tr>		<td>Identifies the <var>READ</var> field level security access level for the files making up the group. The default is 0. </td> </tr>

	<tr> <th><var>SELLVL</var></th>		<tr>
			<th><var>SELLVL</var></th>
	<td>Identifies the <var>SELECT</var> access level for the fields in the files making up the group. The default is 0. </td> </tr>		<td>Identifies the <var>SELECT</var> access level for the fields in the files making up the group. The default is 0. </td> </tr>

	<tr> <th><var>SEMIPUB</var></th>		<tr>
			<th><var>SEMIPUB</var></th>
	<td>Indicates that users are asked for a group password to open the group. If the password is valid, the group is opened with the privileges assigned to that password. If the password is invalid, the group is opened with the default group privileges. </td> </tr>		<td>Indicates that users are asked for a group password to open the group. If the password is valid, the group is opened with the privileges assigned to that password. If the password is invalid, the group is opened with the default group privileges. </td> </tr>

	<tr> <th><var>UPDTFILE</var></th>		<tr>
			<th><var>UPDTFILE</var></th>
	<td>Defines the group's update file.		<td>Defines the group's update file.
	<p>If used in PQO, <var>UPDTFILE</var> can refer to either local or remote files. If the update file you are naming is a remote file, you can include its remote file specification (AT <var class="term">location</var>). </p>		<p>If used in PQO, <var>UPDTFILE</var> can refer to either local or remote files. If the update file you are naming is a remote file, you can include its remote file specification (AT <var class="term">location</var>). </p>
	</td> </tr>		</td> </tr>

	<tr> <th><var>UPDTLVL</var></th>		<tr>
			<th><var>UPDTLVL</var></th>
	<td>Identifies the <var>UPDATE</var> field level security access level for the files making up the group. The default is 0.		<td>Identifies the <var>UPDATE</var> field level security access level for the files making up the group. The default is 0.
	</td> </tr>		</td> </tr>

ELowell: /* Syntax */ - minor table formatting

2017-03-31T16:48:58Z

Syntax: - minor table formatting

← Older revision		Revision as of 16:48, 31 March 2017
Line 91:		Line 91:
	<var>BLDGFT</var> is ignored for groups that include remote members.</p></td> </tr>		<var>BLDGFT</var> is ignored for groups that include remote members.</p></td> </tr>

	<tr> <th><var>MAXFAIL</var></th> <td>		<tr> <th><var>MAXFAIL</var></th> <td>For scattered groups (PQO), the maximum number of optional members that can be unavailable. If more than <var>MAXFAIL</var> files are unavailable, the group fails to open or operations on the group are aborted.
	<p>For scattered groups (PQO), the maximum number of optional members that can be unavailable. If more than <var>MAXFAIL</var> files are unavailable, the group fails to open or operations on the group are aborted.~~</p>~~
	<p>The value of <var>MAXFAIL</var> must be one of the following: </p>		<p>The value of <var>MAXFAIL</var> must be one of the following: </p>
	<ul>		<ul>
Line 136:		Line 135:

	<tr> <th><var>UPDTLVL</var></th>		<tr> <th><var>UPDTLVL</var></th>
	<td>		<td>Identifies the <var>UPDATE</var> field level security access level for the files making up the group. The default is 0.
	<p>Identifies the <var>UPDATE</var> field level security access level for the files making up the group. The default is 0. ~~</p>~~
	</td> </tr>		</td> </tr>
	</table>		</table>

JAL: add ID

2017-02-23T22:47:01Z

add ID

← Older revision		Revision as of 22:47, 23 February 2017
Line 112:		Line 112:
	<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>		<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>		<tr> <th id="PROCFILE"><var>PROCFILE</var></th>
	<td>Defines the group's procedure file. Multiple procedure files can be specified with <code>PROCFILE = *</code>, as explained in [[CREATE command: Temporary group#Temporary group parameters\|Temporary group parameters]].		<td>Defines the group's procedure file. Multiple procedure files can be specified with <code>PROCFILE = *</code>, as explained in [[CREATE command: Temporary group#Temporary group parameters\|Temporary group parameters]].
	<p>		<p>

JAL: misc formatting

2017-02-23T22:16:16Z

misc formatting

Show changes