FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-101
INFO DETAIL Listing Format
In Example 2-6, DETAIL Format for SQL Tables and Indexes and for Enscribe and
OSS Files, on page 2-100, 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.
6. CODE is the file code. File codes are displayed for SQL tables and indexes and for
Enscribe files. The default file code of 0 is not displayed.
18- EXTENTS ALLOCATED: num-ext
19- INDEX LEVELS: num-index-levels
20- 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
To Next Page
Loading...
Need help?
General