NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-18
DETAIL Display for Objects (Except Views) and
Guardian Files
•
KEY key-descriptor is one or more sets of the following items; the number of
sets depends on the number of columns in the key:
COLUMN col-num, OFFSET key-offset,
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
record.
°
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 or clustering key used for
locking (including the SYSKEY if it exists).
•
DCOMPRESS indicates keys in data blocks of the file are compressed.
•
ICOMPRESS indicates keys in index blocks are compressed.
12. This section describes indexes of a table or describes alternate key files for an
Enscribe file:
•
The key-spec value is the key specifier stored in every row of the index. See
CREATE INDEX Statement on page C-133 for more information.
•
FILE indicates the number of an Enscribe alternate key file.
•
The key-descriptor value of the index or alternate key file is displayed as
described for the KEY item in note 11.
•
UNIQUE or NO UNIQUE indicates whether the indexed column or columns
can have the same value or set of values in two or more rows.
•
UPDATE or NO UPDATE indicates whether key specifiers of Enscribe files are
automatically updated.
•
NULL indicates the null value set for an Enscribe file key.
13. If the object or file is partitioned, the partitions are described in this section. The
partition number and volume name of each partition are followed by the number of
primary and secondary extents and the maximum extent size allowed. For a key-
sequenced file, the FIRST KEY value is given.
If a file uses multibyte characters, the FIRST KEY value might contain characters
unsupported by your terminal, causing unpredictable results in the screen display.