SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-15
DETAIL Display for Objects (Except Views) and
Guardian Files
16. PART (part-num, $volume,
pri-ext PAGES, sec-ext PAGES, MAXEXTENTS
max-ext, FORMAT format-type,firstkey-value)
17. ODDUNSTR
REFRESH
AUDIT
BUFFERSIZE
BUFFERED
AUDITCOMPRESS
VERIFIEDWRITES
SERIALWRITES
INCOMPLETE SQLDDL OPERATION
UNRECLAIMED FREESPACE
18. OWNER group-id, owner-id
SECURITY (RWEP):rwep, PROGID,
CLEARONPURGE, LICENSE
NOPURGEUNTIL:expire-time
19. SECONDARY PARTITION
20. MODIF: modif, open-state
CREATION DATE: create-time
REDEFINITION DATE: redefinition-time
LAST OPEN: last-open-time
21. EOF eof (percent-used % USED)
22. EXTENTS ALLOCATED: num-ext
23. INDEX LEVELS: num-index-levels
24. PARTITION ARRAY {EXTENDED | STANDARD | FORMAT2ENABLED}
25. Files managed by SMF,
LOGICAL NAME: logical-file-name for physical files
PHYSICAL NAME: physical-file-name for logical files
This list describes the items in the DETAIL display:
1. The object-type value describes what type of object the file is:

SQL table or view

catalog table

collation

index

catalog index

Enscribe file

Enscribe file containing an SQL object program

OSS file

OSS file containing an SQL object program