SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-36
Examples—PURGE
Examples—PURGE

This example deletes all Enscribe files, SQL programs, and SQL objects (except
for catalog table and indexes) on subvolume $VOL1.PERSNL. The exclamation
point suppresses the PURGE confirmation prompt.
>> PURGE $VOL1.PERSNL.* ! LISTALL;
Depending on the contents of the subvolume, the response might look like this:
TABLE $VOL1.PERSNL.DEPT PURGED
TABLE $VOL1.PERSNL.EMPLOYEE PURGED
TABLE $VOL1.PERSNL.JOB PURGED
3 OBJECT(S) PURGED

This example deletes tables and files on subvolume SALES that have names that
begin with the letter “O.” The example assumes that three files meet the criteria
and shows the confirmation prompt for the PURGE:
>> VOLUME SALES;
>> PURGE O* NO LISTALL;
DO YOU WISH TO PURGE THE ENTIRE FILESET
$VOL1.SALES.O*
(Y[ES], N[ONE], S[ELECT], F[ILES]) ?S
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK
$VOL1.SALES
ODETAIL A 12288 30Apr9116:42 255,1NUNU K Ta 14 4096
PURGE ? ( Y/N) Y
ORDERS A 12288 30Apr9116:41 255,1NUNU K Ta 16 4096
PURGE ? ( Y/N) Y
ORDREP 255,1NUNU SVi
PURGE ? ( Y/N) N
2 OBJECT(S) PURGED

This example purges all shadow labels on subvolume SALES but does not purge
any other files or objects:
>> PURGE $VOL1.SALES.* SHADOWSONLY NO LISTALL;
PURGEDATA Command
PURGEDATA is an SQLCI utility that clears data from SQL tables and their indexes,
from specified partitions of SQL tables without indexes, or from Enscribe files or
specified partitions of Enscribe files.