SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-10
FILEINFO Command
user-ID is a user's numeric ID such as that displayed by the OSS ls -n command.
user-ID can be in the range from 1 to 65,535. For a Guardian user-ID, this
number equates to (256*group-id + member-ID).
If you specify a user, FILEINFO displays information for files owned by that user. If
you specify only the keyword USER, FILEINFO displays information only for files
that you own. If you omit the USER option, FILEINFO displays information about
all files in qualified-fileset-list.
BRIEF | DETAIL
specifies whether to display brief or detailed information about each file. BRIEF, the
default, displays only a single line of information.
EXTENTS
displays information on the allocation of extents for each file. Extent information
appears for tables, indexes, collations, and Enscribe files, but not for views or OSS
files.
STAT[ISTICS] [ , PARTONLY ]
provides all the DETAIL information and statistical data on blocks and records for
each file. Statistics information appears only for tables, indexes, collations, and
Enscribe structured files; it does not appear for shadow labels or OSS files.
PARTONLY limits the information to the partitions you specify explicitly in
qualified-fileset-list. For example, if you specify only a secondary
partition of a table, no statistical information about the primary partition or any other
secondary partition appears. PARTONLY affects only the output and has no effect
on how SQL reads the input file.
If you omit PARTONLY and specify the primary partition of an Enscribe file or
specify any partition of an SQL object, FILEINFO supplies information about all
partitions. For Enscribe files, PARTONLY is implied if you specify a secondary
partition, because secondary partitions do not contain information about other
partitions.
SHADOWS
specifies that you want to display information about shadow labels, temporary file
labels for objects that have been dropped.
You can specify the DETAIL, EXTENTS, and STATISTICS display together in the
same command.