SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

F-25

FILENAMES Command

FILENAMES is an SQLCI utility command that displays a set of file names that match

a pattern specified with wild-card characters. You can restrict the list to objects

described in specified catalogs.

qualified-fileset-list

specifies the files for which information is to be displayed. For more information,

see Qualified Fileset List on page Q-1. If you omit qualified-fileset-list,

FILENAMES displays the files on the current default subvolume.

If 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.

Example—FILENAMES

This example lists all files in subvolumes that begin with the letter W, have file names

that begin with the letters SQ, have the number 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;

FILENAMES [ qualified-fileset-list ] ;