SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-16
DETAIL Display for Objects (Except Views) and
Guardian Files

INVALID indicates that an SQL program is not valid and might need to be SQL
compiled.

SHADOW LABEL indicates that the file is a shadow label.

SQL CHARACTER PROCESSING RULES OBJECT indicates that the object
is a collation.
2. CATALOG identifies the catalog in which the object is defined.
3. VERSION indicates a NonStop SQL/MP version number. This information is
supplied only for SQL objects.
4. PROGRAM CATALOG VERSION (PCV) indicates the oldest version catalog in
which the SQL program can be registered. The PCV of a program depends on the
program's use of SQL/MP features that require information to be recorded in the
catalog. This information is supplied only for SQL programs.
5. PROGRAM FORMAT VERSION (PFV) indicates the oldest version of SQL/MP
software that can execute the SQL program. The PFV of a program is the SQL/MP
software version of the SQL compiler that compiled the program. This information
is supplied only for SQL programs.
6. BASE TABLE is the underlying table if the file is an index.
7. TYPE indicates the file organization:
K Key-sequenced
E Entry-sequenced
R Relative
U Unstructured
8. FORMAT indicates the partition format, 1 or 2.
9. CODE is the file code. For more information, see the discussion of file code in the
preceding description of the BRIEF display.
10. EXT lists the sizes of the primary and secondary extents and the maximum number
of extents that can be allocated.
11. Items in this section do not appear for unstructured files:

REC indicates the maximum exploded record length for objects. (A record in
“exploded format” is expanded to its maximum length; varying-length character
fields are padded with blanks to their full maximum size and filler is generated
where necessary to align numeric fields that require word alignment.)

PACKED REC indicates the maximum packed record length for objects.
(Records on disk are stored in packed format. A record in packed format has
no fillers; varying length character fields are stored as their exact size plus the
length field and numeric items are not necessarily word aligned.)

RECLENGTH indicates the maximum row length for relative tables. For more
information, see RECLENGTH File Attribute
on page R-1.

BLOCK indicates the number of bytes in a block.