DELETE command: Temporary group

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.