SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
Q-5
Examples—Qualified Fileset List
name. (To determine the processing order to select the appropriate startfile,
issue a FILENAMES command with the same qualified fileset list used for the
utility.)
startfile is a Guardian file name that can optionally include the wild-card
character * as the subvolume or file id portion of the name. The file or set of files
that startfile specifies must be a subset of the fileset to which the clause
applies.
Examples—Qualified Fileset List

This example displays information for all objects on subvolume $VOL1.PERSNL
that are described in the PERSNL catalog:
>> FILEINFO $VOL1.PERSNL.* FROM CATALOG $VOL1.PERSNL;

This example displays information for all SQL objects in key-sequenced files on
volume $VOL1 that were created before April 5, 1989:
>> FILEINFO $VOL1.*.* WHERE KEYSEQUENCED AND SQL
+> AND CREATIONTIME < APR 5 1989;

This example might be useful after an interrupted SECURE operation that changes
ownership of a set of SQL objects. The command changes ownership for only
those SQL objects on volume $VOL1 described in the catalog $VOL1.SALES,
beginning with the file SALES.ODETAIL:
>> SECURE $VOL1.*.* FROM CATALOG $VOL1.SALES
+> START $VOL1.SALES.ODETAIL,
+> OWNER 302,92;

This example purges objects from the volume $VOL1 that are registered in the
catalog that a previous ADD DEFINE or ALTER DEFINE command specified for
the =CAT logical DEFINE name:
>> PURGE $VOL1.*.* FROM CATALOG =CAT;