DELETE command: Temporary group

From m204wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.