SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-17
DETAIL Display for Objects (Except Views) and
Guardian Files
12. This section describes the primary key of a key-sequenced file or other structured
file types:

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
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.
13. 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. For
more information, see CREATE INDEX Statement
on page C-142.

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.
14. 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. The
partition’s format, 1 or 2, is shown. For a key-sequenced file, the FIRST KEY value
is given.