
FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-102
INFO DETAIL Listing Format
File codes in the range 100 through 999 refer to specific types of files and are
reserved by HP. For a description of these codes, see
Table 2-2, System File Code
Definitions,
on page 2-90.
Letters that follow the file code have specific meanings:
7. Lists the sizes of the primary (
pri-num
) and secondary (
sec-num
) extents, and
the maximum number of extents that can be allocated.
8. The items in this section do not appear for unstructured files:
REC indicates the maximum exploded record length for objects.
PACKED REC indicates the maximum packed record length for objects.
RECLENGTH indicates the maximum record length for relative tables.
BLOCK indicates the length of a block.
9. Describes the primary key of a key-sequenced file or other structured file type:
IBLOCK is the length of an index block of an Enscribe file.
KEY
key-descriptor
is one or more sets of these items (the number of sets
is determined by the number of columns in the key):
COLUMN col-num, OFFSET key-offset, TYPE col-type
LENGTH key-length, {ASC }
{DESC}
COLUMN number indicates the position of the key column in the row. If the
row contains a system-defined primary key, the primary key is column 0.
Otherwise, the first column defined for the table is column 0.
OFFSET indicates the zero-relative byte address of the key column in the
exploded record.
TYPE indicates the data type of the column. The data types supported by
SQL/MX are a superset of the data types supported by SQL/MP.
LENGTH indicates the length of the key column in bytes.
ASC is ascending order, and DESC is descending order.
SYSKEY indicates a system-defined primary key.
LOCKLENGTH is the number of bytes of the primary key used for locking.
DCOMPRESS indicates keys in data blocks of the file are compressed.
A
TMF audits the file.
L
The file is licensed by the super ID (255,255).
P
The PROGID security attribute of the file is on.
Note.
The TYPE and LENGTH fields are not displayed for SQL/MX objects if SQL/MX
returns default values (zeroes) for these fields.
Содержание G08
Страница 4: ......
Страница 290: ...FUP Messages File Utility Program FUP Reference Manual 523323 014 3 38 ...
Страница 296: ...FUP Command Summary File Utility Program FUP Reference Manual 523323 014 B 4 ...
Страница 310: ...FUP Command Syntax Summary File Utility Program FUP Reference Manual 523323 014 C 14 ...