NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
P-32
PURGE Command
If PURGE cannot delete objects because of missing objects or bad labels, use
CLEANUP instead.
[!]qualified-fileset-list[!]
is a qualified fileset list that specifies the items to purge. (See Qualified Fileset List
on page Q-1.)
The leading or trailing exclamation point (!) suppresses the interactive confirmation
dialog, which is as follows:
DO YOU WISH TO PURGE THE ENTIRE FILESET
<names of groups of files listed vertically>
(Y[ES], N[ONE], S[ELECT], F[ILES]) ?
Respond to the prompt with one of the following:
If qualified-fileset-list includes any partition of a partitioned SQL
object or the primary partition of an Enscribe file, SQL purges all partitions of the
SQL object or Enscribe file. However, if qualified-fileset-list includes
secondary partitions of an Enscribe file, but not the primary partition of the file,
SQL purges only the secondary partitions included in the list.
If ServerWare SMF is installed on your node, qualified-fileset-list
cannot specify any objects or files on a $*.ZYS*. subvolume.
PURGE [!] qualified-fileset-list[!] [ [,]option]... ;
option is:
{ ALLOWERRORS [ ON | OFF | num ] }
{ [ NO ] LISTALL }
{ SHADOWSONLY }
YES Purge the entire set of files
NONE Cancel the PURGE command
SELECT Display information about each file (as in BRIEF format from the
FILEINFO command) and then prompt again about that file
FILES Display names of all files that belong to the specified group, then prompt
again