NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Q-2
Qualified Fileset List
fileset
is a set of objects and files specified as a Guardian name that optionally includes the
following 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 ServerWare 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 as follows:
{ catalog-name }
{ ( catalog-name [ , catalog-name ] ... ) }
catalog-name cannot include wild-card characters, but can be a DEFINE.
If ServerWare 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.