SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
Q-2
Qualified Fileset List
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.
Notice that a single fileset used with wild-card characters can represent a
fileset that includes many objects and files.
You cannot use a wild-card character 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 name you specify in the DEFINE. As a result, a fileset you
specify with a DEFINE always consists of a single object or file.
If SMF is installed on your node, fileset cannot specify a file or object on a
$*.ZYS*. subvolume.
FROM CATALOG[S] catalogs
restricts operations to files in fileset that are also in the specified catalogs. For
example, this clause excludes Enscribe files in fileset because Enscribe files
are not described in any SQL catalog.
Specify catalogs:
{ catalog-name }
{ ( catalog-name [ , catalog-name ] ... ) }
catalog-name cannot include wild-card characters, but can be a DEFINE.
If SMF is installed on your node, catalog-name must be either a logical or direct
file.
WHERE expression
restricts operations to files in fileset that meet the criteria specified by
expression. expression can include parentheses, and NOT, AND, and OR
operators. Parentheses have the highest precedence, followed by the others in the
order shown.
? 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; *VOL* matches
NEWVOL, OLDVOL1, VOL45, and so forth.