SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-9
FILEINFO Command
For information about choosing the most effective file organizations for your tables, see
the SQL/MP Installation and Management Guide.
FILEINFO Command
FILEINFO is an SQLCI utility that displays information about the versions and physical
characteristics of tables, indexes, views, collations, Enscribe files, and OSS files.
FILEINFO is similar to FUP INFO, although its displays are slightly different.
qualified-fileset-list
is a qualified fileset list that specifies files for which to display information. For
information, see Qualified Fileset List on page Q-1.
You cannot include a pathname in a qualified fileset list; use Guardian-format ZYQ
names to specify OSS files.
USER [ group.member ] }
[ group-ID,member-ID ] }
[ "user-name" ] }
[ user-ID ] }
restricts the files for which information is displayed to those from
qualified-fileset-list that are owned by the specified user.
You can specify user in one of several ways:
group.member is a valid user name.
group-id, member-ID specifies the user ID as a pair of numbers, each in the
range from 1 to 255.
“user-name” is a valid Guardian user name (in group.member format) or
Safeguard alias name, enclosed in double quotes. To add a Safeguard alias, use
the Safecom utility.
FILEINFO qualified-fileset-list
[[,]fileinfo-option] ... ;
fileinfo-option is:}
{ USER [ group.member ] }
{ [ group-ID,member-ID ] }
{ [ "user-name" ] }
{ [ user-ID ] }
{ [ BRIEF | DETAIL ] }
{ EXTENTS }
{ STAT[ISTICS] [ , PARTONLY ] }
{ SHADOWS }