SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-27
FILES Table
FILES Table
The FILES table is a catalog table that describes the attributes of files that contain
tables and indexes. Table F-2 describes the contents of the FILES table.
Table F-2. The FILES Table (page 1 of 2)
Column Name Data Type Description
1 FILENAME * CHAR(34) File name (same name as table,
index, or partition in file)
2 FILETYPE CHAR(1) E if entry-sequenced
R if relative
K if key-sequenced
3 BLOCKSIZE SMALLINT
SIGNED
Block size in bytes: 512, 1024, 2058,
or 4096
4 PRIMARYEXT SMALLINT
UNSIGNED
Size of primary extent in units of 2
KB. Superceded by PRIMARYEXT2
5 SECONDARYEXT SMALLINT
UNSIGNED
Size of secondary extent in units of 2
KB. Superceded by
SECONDARYEXT2
6 MAXEXTS SMALLINT
SIGNED
Maximum number of extents in file
(both primary and secondary)
7 LOCKLENGTH SMALLINT
SIGNED
Locklength file attribute;
0 if same as primary key
8 PARTITIONED CHAR(1) Y if partitioned
N if not
9 AUDIT CHAR(1) Y if audited by TMF
N if not
10 DCOMPRESS CHAR(1) Y if data keys compressed
N if not
11 ICOMPRESS CHAR(1) Y if index keys compressed
N if not
12 CLEARONPURGE CHAR(1) Y if all data in file is physically erased
from disk when file purged
N if not
13 SERIALWRITES CHAR(1) Y if serial mirror writes
N if parallel
14 VERIFIEDWRITES CHAR(1) Y if disk read follows each disk write
N if not
15 BUFFERED CHAR(1) Y if writes to disk are buffered
N if not
16 NOPURGEUNTIL LARGEINT
SIGNED
Julian timestamp of earliest time file
can be purged; 0 if file can be purged
any time