SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-13
BRIEF Display for SQL Objects and Guardian Files
TYPE A six-character code that identifies the file type and SQL object type in
this form:
Character positions -> 1 2 3 4 56
Codes that appear -> X P E A In
K P Pg
R S Ta
Vi
Character Code
Position
Meaning
1 X Secondary Partition
2 P Partitioned Table, protection view or file
3 E
K
R
Blank
Entry-sequenced file structure
Key-sequenced file structure
Relative file structure
View or unstructured file
4 A
P
S
Blank
Enscribe file with alternate key
Protection view
Shorthand view
Tables, indexes, collations, and files without
alternate keys
5-6 In
Pg
Ta
Vi
Blank
Index
SQL object program file
Table
View
Collations and Enscribe files that are not SQL
object program files. (To determine which, use
the DETAIL option.)
REC The record length in bytes. For tables and indexes, REC is the maximum
record length; for Guardian files, REC is the logical record length. (Not
displayed for views or unstructured files.)
BLOCK The number of bytes in each block of a file. (Not displayed for views or
unstructured files.)
Table F-1. FILEINFO BRIEF Display Information Line (page3of3)
Open State The open state of the file is described by one or more of these codes: