DELETE command: Temporary group

From m204wiki
Revision as of 16:18, 22 March 2017 by ELowell (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Summary

Privileges
Any user
Function
Deletes a temporary group

Syntax

DELETE [TEMP] GROUP groupname

Where: groupname is the name of an existing Model 204 temporary file group.

Syntax notes

If TEMP 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. (Note that a permanent group is deleted only if you are a system manager.)

Example

DELETE TEMP GROUP DAYS DELETE GROUP SET7

Usage notes

The DELETE TEMP GROUP command deletes a temporary group that you have defined. A temporary group is a group that is created only for use by an individual user. It exists only for the current login session and is deleted automatically when you log out.

When a file group is deleted, Model 204 removes the group from all of the system tables that contain group entries.

DELETE TEMP GROUP applies to Parallel Query Option/204 scattered groups.