SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-29
Filesets
Filesets
A fileset is a set of objects and files specified as a Guardian name that optionally
includes these wild-card characters in the volume, subvolume, or file-id portions
of the name:
*VOL* matches NEWVOL, OLDVOL1, VOL45, and so forth.
Notice that a single Guardian name that includes wild-card characters can represent a
fileset that includes many files. You cannot use a wild-card in the node portion of a
Guardian name that specifies a fileset.
You can use a DEFINE to specify a fileset, but you cannot use wild-card characters in
the DEFINE name or in the file name you specify on the DEFINE. As a result, a fileset
you specify with a DEFINE always consists of a single object or file.
Many SQLCI commands allow you to use filesets or fileset lists to specify a set of
tables and files for the command. A fileset list can be a simple fileset list or a qualified
fileset list.
A simple fileset list is a list of one of more filesets in this form:
{ fileset }
{ ( fileset [ , fileset ] ... ) }
A qualified fileset list can include clauses that restrict the files in the set in various
ways. For information, see Qualified Fileset List
on page Q-1.
Examples—Filesets

This example on FILEINFO requests information about the fileset that includes all
files on subvolume \NY.$HDQTR.HR:
FILEINFO \NY.$HDQTR.HR.*;

This PURGE command purges the fileset that includes all files on subvolume SV3
with names that end in X:
PURGE SV3.*X;
? matches any single character.
For example, TBL? matches TBL1 or TBLX but not TBL48.
* matches any 0 to 8 characters.
For example, * matches any 0 to 8-character name.