SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-14
DETAIL Display for Objects (Except Views) and
Guardian Files
DETAIL Display for Objects (Except Views) and Guardian Files
This listing shows all the detail that can appear if you specify the DETAIL option when
you request FILEINFO for a table, index, collation, or Guardian file. The information
that actually appears in your listing depends on the file organization of the item you
inquire about and on whether the item is a table, index, collation, or file.
The KEY descriptors, INDEX and ALTKEY, and PART information do not appear for
shadow labels. The SMF information appears only for files managed by SMF.
The name of the object or file and the date when the listing is produced appear in the
first line. The numbers in the left most column do not appear in the listing. These
numbers relate sections of the listing to the notes and explanations that follow.
file-name date-and-time
1. object-type
2. CATALOG catalog-name
3. VERSION version-number
4. PROGRAM CATALOG VERSION version-number
5. PROGRAM FORMAT VERSION version-number
6. BASE TABLE base-table-name
7. TYPE organization-type
8. FORMAT format-type
9. CODE file-code
10. EXT (pri-num PAGES, sec-num PAGES, MAXEXTENTS max-extents)
11. REC record-length
PACKED REC packed-record-length
RECLENGTH max-record-length
BLOCK block-length
12. IBLOCK block-length
KEY (key-descriptor)
SYSKEY
LOCKLENGTH lock-length
DCOMPRESS, ICOMPRESS
13. For each index or alternate key of the object or file:
14. {INDEX} (key-spec, FILE alt-fnum, file-name,
{ALTKEY} key-descriptor
{UNIQUE | NO UNIQUE},
{UPDATE | NO UPDATE}, NULL null-value)
15. For each partition of the object or file: