NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-27
Examples—FILENAMES
If ServerWare SMF is installed on your node, qualified-fileset-list can
include files on $*.ZYS*. subvolumes. If you specify FROM CATALOG(S), all
specified catalogs must be either logical or direct files.
FILENAMES displays file names on the OUT file, which is typically your terminal.
For OSS files, FILENAMES displays ZYQ names.
Examples—FILENAMES
•
The following command lists all files in subvolumes that begin with the letter W,
have file names that begin with SQ, have the character 2 in the fifth character
position, and are exactly five characters long:
>> FILENAMES W*.SQ??2;
To restrict the list to files created after December 31, 1994, and owned by user 12 of
group 48, enter:
>> FILENAMES W*.SQ??2 WHERE CREATIONTIME AFTER DEC 31 1994
+> AND OWNER = 48,12;
FILES Command
FILES is an SQLCI utility command that displays the names of files that are on one or
more subvolumes.
subvol-spec
is the name of a Guardian subvolume or a name with wild-card characters that
matches the names of several Guardian subvolumes.
If you do not specify any subvol-spec, FILES displays the files on the current
default subvolume.
subvol-spec can include the following wild-card characters in any part of the
name except the node name:
FILES displays file names on the OUT file, which is typically your terminal. For
OSS files, FILES displays ZYQ names.
FILES [ subvol-spec ] ;
[ ( subvol-spec [ , subvol-spec ] ... ) ]
* matches zero or more characters
? matches any single character