File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-106
INFO DETAIL Listing Format
In Example 2-6, DETAIL Format for SQL Tables and Indexes and for Enscribe and
OSS Files, on page 2-105, the headers and variables are:
1. object-type indicates whether the file is an SQL/MP or SQL/MX base table,
catalog table, index, or catalog index; Enscribe file; or Enscribe file containing an
SQL/MP or SQL/MX object program.

INVALID indicates that an SQL/MP or SQL/MX object program is not valid and
might need to be SQL/MP or SQL/MX compiled.

SHADOW LABEL indicates that the file is a shadow label. This file label exists
temporarily after an SQL/MP or SQL/MX object is dropped and until the
transaction is committed.
2. CATALOG identifies the catalog in which the object is defined. VERSION is the
SQL/MX software version. (For more information about SQL/MX versioning, see
the SQL/MX Database and Application Migration Guide.) If the file is an index,
BASE TABLE is the underlying table.
3. PHYSICAL FILENAME indicates a logical file by its logical name. VIRTUAL
FILENAME indicates a logical file by its physical name.
4. TYPE indicates the file organization:
5. FORMAT is the new file’s format designator, which can have these values:
If you omit the FORMAT option, the system decides the file format based on other
file attributes.
17- AGGREGATE EOF aggregate eof(percent-used % USED)
18- FILE LABEL: num-bytes(percent-used % USED)
19- EXTENTS ALLOCATED: num-ext
20- INDEX LEVELS: num-index-levels
21- PARTITION ARRAY {EXTENDED | STANDARD | FORMAT2ENABLED}
Note. If you do not have access privileges to a file and you issue the INFO DETAIL command,
UNAVAILABLE is displayed as the pathname.
K Key sequenced
E Entry sequenced
RRelative
U Unstructured
Format
Designator Indicates the File Should Be a...
1 Format 1 file as described in Handling File Formats
on page 1-22
2 Format 2 file as described in Handling File Formats
on page 1-22