File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-87
INFO
FUP long INFO for a TABLE or INDEX displays the information about a single partition
as all the partitions contain the same information in the long form.
OUT listfile
names an existing disk file or device to receive the listing output of the FUP INFO
command. The OUT listfile defaults to your home terminal. You can use either
a standard file name or a spool DEFINE name as the OUT listfile. If
listfile is an existing file, FUP appends output to that file.
fileset-list
is a list of disk files for which the file characteristics are displayed. The
fileset-list can include Enscribe files, OSS files, and all types of SQL/MP and
SQL/MX files (tables, indexes, views, catalog tables, and indexes on SQL/MP and
SQL/MX catalog tables). If you omit fileset-list, the INFO command displays
characteristics for all files in the current subvolume. You can specify
qualified-fileset for fileset-list.
To display information for temporary files only, you must explicitly specify # in the
file name. The file name can contain a wild card, as in INFO #*. You can use the
asterisk (*) wild-card character alone or with other characters. For example, to
display information for all temporary files that end in 1:
INFO #*1
The command INFO *.* does not display temporary files.
ansiname-list
ansiname-list = ‘ansiname’ [, ‘ansiname’ ]...
identifies SQL/MX ANSI name tables, indexes, partitions of tables and indexes,
and any combination of these objects. A single quote ( ' ) is required to precede
INFO [ / OUT listfile / ] [ fileset-list / ansiname-list ]
[ , DETAIL ]
[ , EXTENTS ]
[ , STAT[ISTICS] [ , PARTONLY | PARTIAL num ] ]
[ , USER { groupnum , usernum }
{ groupname.username } ]
[ , AGGREGATE EOF aggregate eof(percent-used % USED) ]
Note. For more information, see Specifying Files on page 1-8.