SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-28
FILES Table
The columns FILENAME through RECORDSIZE (1 through 19) were created in
version 1. The column AUDITCOMPRESS (20) was added in version 2. The column
PARTITIONARRAY (21) was added in version 320. Column DCOMPRESSTYPE was
added in version 345. Columns PRIMARYEXT2, SECONDARYEXTENT2, and EOF2
were added in version 350 and supercede PRIMARYEXT, SECONDARYEXTENT, and
EOF.
Guardian names in the FILES table are fully qualified and use uppercase characters.
17 EOF INTEGER
SIGNED
Relative byte address of first unused
byte of last block in partition or file;
updated by UPDATE STATISTICS.
Superceded by EOF2.
18 NONEMPTYBLOCKCOUNT LARGEINT
SIGNED
Number of blocks that contain at least
one row of data; updated by UPDATE
STATISTICS
19 RECORDSIZE SMALLINT
SIGNED
Maximum length of packed record
20 AUDITCOMPRESS CHAR(1) Y if AUDITCOMPRESS
N if not
21 PARTITIONARRAY CHAR (30) STANDARD if the type of partition
array is that used by default
EXTENDED if the type of partition
array is extended and supports
additional partitions
FORMAT2ENABLED if the type of
partition array supports both FORMAT
1 and FORMAT 2 partitions
22 DCOMPRESSTYPE CHAR(1) 1 if DCOMPRESS
2 if DCOMPRESS2
23 PRIMARYEXT2 INTEGER
UNSIGNED
Size of primary extent in units of 2 KB
24 SECONDARYEXT2 INTEGER
UNSIGNED
Size of secondary extent in units of 2
KB
25 EOF2 LARGEINT
SIGNED
Relative byte address of first unused
byte of last block in partition or file;
updated by UPDATE STATISTICS
26 FILEFORMAT CHAR(1) Format of partition:
1 if FORMAT 1
2 if FORMAT 2
* Indicates primary key
Table F-2. The FILES Table (page 2 of 2)
Column Name Data Type Description