DELETE command: Permanent group: Difference between revisions
m (Automatically generated page update) |
|||
| Line 22: | Line 22: | ||
<p>When a file group is deleted, <var class="product">Model 204</var> removes the group from all of the system tables that contain group entries. The DELETE command does not execute when multiple procedure files are specified for a group. In this case, DELETE must be used in a file context. </p> | <p>When a file group is deleted, <var class="product">Model 204</var> removes the group from all of the system tables that contain group entries. The DELETE command does not execute when multiple procedure files are specified for a group. In this case, DELETE must be used in a file context. </p> | ||
<p>DELETE PERM GROUP applies to Parallel Query Option/204 scattered groups.</p> | <p>DELETE PERM GROUP applies to Parallel Query Option/204 scattered groups.</p> | ||
<p>When it processes DELETE PERM GROUP, <var class="product">Model 204</var> ends any current User Language update unit and begins a non-backoutable update unit. If a <var class="product">Model 204</var> command non-backoutable update unit is in progress, DELETE PERM GROUP is included in that update unit. For more information about <var class="product">Model 204</var> update units, see | <p>When it processes DELETE PERM GROUP, <var class="product">Model 204</var> ends any current User Language update unit and begins a non-backoutable update unit. If a <var class="product">Model 204</var> command non-backoutable update unit is in progress, DELETE PERM GROUP is included in that update unit. For more information about <var class="product">Model 204</var> update units, see [[File integrity and recovery]].</p> | ||
[[Category: System manager commands]] | [[Category: System manager commands]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 23:10, 14 April 2017
Summary
- Privileges
- System manager
- Function
- Deletes a permanent group
Syntax
DELETE [PERM] GROUP groupname
Where: groupname is the name of an existing Model 204 permanent file group.
Syntax notes
If PERM is not specified, Model 204 assumes a temporary group. If a temporary group having the specified name cannot be found, Model 204 searches for a permanent group.
Example
DELETE PERM GROUP KEYS DELETE GROUP SET8
Usage notes
A permanent group is stored in an external file until explicitly deleted by the system manager.
When a file group is deleted, Model 204 removes the group from all of the system tables that contain group entries. The DELETE command does not execute when multiple procedure files are specified for a group. In this case, DELETE must be used in a file context.
DELETE PERM GROUP applies to Parallel Query Option/204 scattered groups.
When it processes DELETE PERM GROUP, Model 204 ends any current User Language update unit and begins a non-backoutable update unit. If a Model 204 command non-backoutable update unit is in progress, DELETE PERM GROUP is included in that update unit. For more information about Model 204 update units, see File integrity and recovery.