SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

P-33

PURGE Command

PURGE is an SQLCI utility that deletes SQL objects (except catalog tables and their

indexes), SQL programs in Guardian files, and Enscribe files. For an SQL object,

PURGE deletes the file that contains the object, the catalog entries for the object, and

objects (but not programs) that depend upon the object.

The local super ID (but not other users) can also use PURGE to delete shadow labels.

You cannot PURGE constraints or catalogs. Use DROP instead.

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:

DO YOU WISH TO PURGE THE ENTIRE FILESET

(Y[ES], N[ONE], S[ELECT], F[ILES]) ?

Respond to the prompt with one of these:

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 the

secondary partitions of an Enscribe file, but not the primary partition of the file, SQL

purges only the secondary partitions included in the list.

PURGE [!] qualified-fileset-list[!] [ [,]option]... ;

option is:

{ ALLOWERRORS [ ON | OFF | num ] }

{ [ NO ] LISTALL }

{ SHADOWSONLY }

YES Purge the entire set of files

SELECT Display information about each file (as in BRIEF format from the

FILEINFO command) and then prompt again about that file

NONE Cancel the PURGE command

FILES Display names of all files that belong to the specified group, then

prompt again