DELETE command: Permanent group

From m204wiki
Revision as of 23:10, 14 April 2017 by ELowell (talk | contribs) (→‎Usage notes)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.