NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-28
Examples—FILES
Examples—FILES
•
The following example lists all files in volumes with names that end with the letter
M and subvolumes on those volumes that have names that are six-characters long
beginning with Z, with 00 in the fifth and sixth character positions:
>> FILES $*M.Z???00;
$SYSTEM.ZLOG00
ZZEV0011 ZZEV0012 ZZEV0013 ZZEV0014 ZZEVCONF
>>
FILES Table
The FILES table is a catalog table that describes the attributes of files that contain tables
and indexes. The following table describes the contents of the FILES table.
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
5 SECONDARYEXT SMALLINT
UNSIGNED
Size of secondary extent in units of 2 KB
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
* Indicates primary key