DELETE command: Temporary group
- Any user
- Deletes a temporary group
DELETE [TEMP] GROUP groupname
Where: groupname is the name of an existing Model 204 temporary file group.
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.)
DELETE TEMP GROUP DAYS DELETE GROUP SET7
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.