SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-20
DETAIL Display for Views
22. For tables and indexes, PARTITION ARRAY indicates the type of array used for
the base table and any associated indexes. Possible values are:
23. For files managed by SMF, this section indicates the corresponding file name.
Possible values are:

LOGICAL NAME, virtual-volume-name.subvolume.file-name
displayed when you execute FILEINFO, DETAIL for a physical file

PHYSICAL NAME, physical-volume-name.subvolume.file-name
displayed when you execute FILEINFO, DETAIL for a logical file
DETAIL Display for Views
This figure shows all the information that can appear if you specify the DETAIL option
when you request FILEINFO for a view.
Fields with the same names as previously described fields for tables, indexes,
collations, and Guardian files contain similar information.
For protection views, BASE TABLE indicates the name of the underlying table. PART
and REDEFINITION DATE appear for protection views only. If the partition is on the
current system, the system name does not appear. INSERTABLE appears for views for
which you can insert and update values.
EXTENDED Longer partition array available on versions 320 and later
of NonStop SQL/MP.
STANDARD Partition array used by default by NonStop SQL/MP.
FORMAT2ENABLED Partition array that allows partitions to be any
combination of Format 1 or Format 2 partitions.
FORMAT2ENABLED implies that the partition array is
also EXTENDED.
file-name date-and-time
object-type
CATALOG catalog-name
VERSION version-number
BASE TABLE base-table-name
PART ( [\system.] $volume )
...
OWNER group-id,user-id
SECURITY (RWEP): rwep
[ LABEL QUESTIONABLE ]
[ DEFINITION INVALID ]
[ REDO NEEDED, UNDO NEEDED ]
CREATION DATE: creation-date
NOPURGEUNTIL: expire-time
REDEFINITION DATE: redefinition-date
INSERTABLE