NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
P-35
Examples—PURGE
Examples—PURGE
•
The following command 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 the
following:
TABLE $VOL1.PERSNL.DEPT PURGED
TABLE $VOL1.PERSNL.EMPLOYEE PURGED
TABLE $VOL1.PERSNL.JOB PURGED
3 OBJECT(S) PURGED
•
The following 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
•
The following command purges all shadow labels on subvolume SALES but does
not purge any other files or objects:
>> PURGE $VOL1.SALES.* SHADOWSONLY NO LISTALL;