NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Q-5
Examples—Qualified Fileset List
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
•
The following command displays information for all objects on subvolume
$VOL1.PERSNL that are described in the PERSNL catalog:
>> FILEINFO $VOL1.PERSNL.* FROM CATALOG $VOL1.PERSNL;
•
The following command 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;
•
The following command 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;
•
The following command 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;
Quantified Predicate
A quantified predicate compares the value of an expression to all, some, or any of the
values in the result of a subquery.
[ ANY ]
expression comparison-operator [ ALL ] subquery
[ SOME ]
comparison-operator is one of the following:
= Equal
<> Not equal
< Less than
> Greater than
<= Less than or equal to
>= Greater than or equal to