FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-83
INFO
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
and delimit each ansiname. The ANSI names syntax is in accordance with Unified
Syntax Proposal. The syntax is:
SQL-name
is used to name base SQL objects (such as tables or indexes) in addition to
their SQL containers: catalogs and schemas. The names (called 3-part names)
for SQL base objects such as tables, indexes, or modules are composed of
three SQL identifiers separated by two dot characters (for example,
CAT.SCH.T).
Note. For more information, see Specifying Files on page 1-8.
ansiname ::= {TABLE | INDEX} base-mx-object-names
base-mx-object-names ::= base-mx-object-name |
(base-mx-object-name [, base-mx-object-name …] )
base-mx-object-name ::= SQL-name [ partitions ]
partitions ::= PARTITION ( SQL-identifier [, SQL-identifier
…])