SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-24
Examples—FILEINFO
FREE 0
BITMAP 1

This command displays EXTENTS information about PARTLOC:
>> FILEINFO $VOL1.INVENT.PARTLOC, EXTENTS;
$VOL1.INVENT.PARTLOC 30 Oct 1994, 11:00
EXTENT # OF PAGES STARTING PAGE PART
0 16 71199 $VOL1
0 16 141363 $WHS2

This command displays BRIEF information about collations by specifying the file
attribute “COLLATION” in the WHERE clause of the qualified fileset list for
FILEINFO:
>> FILEINFO \A.$A.A.* WHERE COLLATION;
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK
\A.$A.A
CASEINS 941 12288 16NOV93 11:53 175,213NONO K 3004 4096
ESPANOL 941 12288 17NOV93 9:10 175,213NONO K 3004 4096
FRANCAIS 941 12288 15NOV93 17:40 255,255NONO K 3004 4096
FRENCH 941 12288 16NOV93 8:20 175,213NONO K 3004 4096

This FILEINFO command displays DETAIL information for a collation:
>> FILEINFO \A.$A.A.COL1, DETAIL;
\A.$A.A.COL1 1 Jun 1995, 9:51
SQL CHARACTER PROCESSING RULES OBJECT
CATALOG $A.A
VERSION 300
TYPE K
FORMAT 1
CODE 941
EXT ( 16 PAGES, 64 PAGES, MAXEXTENTS 160 )
REC 3004
PACKED REC 3004
BLOCK 4096
KEY (COLUMN 0, OFFSET 0, LENGTH 2, ASC)
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER 175,213
SECURITY (RWEP): CCCC
MODIF: 1 Jan 1992, 7:55
CREATION DATE: 1 Jan 1992, 7:55
REDEFINITION DATE: 1 Jan 1992, 7:55
LAST OPEN: 1 Jan 1992, 7:55
EOF 12288 (0.1% USED)
EXTENTS ALLOCATED: 1
INDEX LEVELS: 1