File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-114
INFO DETAIL Listing Format Examples
Next, issue a CREATE KEY command. (FUP responds by displaying information
on the keys just created.) Then issue an INFO KEY, DETAIL command:
-CREATE KEY
CREATED - $DATAA.DCDTEST.KEY
CREATED - $DATAA.DCDTEST.ALT0
-INFO KEY, DETAIL
$DATAA.DCDTEST.KEY 17 Dec 2000, 16:45
ENSCRIBE
TYPE K
FORMAT 1
EXT (2 PAGES, 2 PAGES)
REC 80
BLOCK 4096
IBLOCK 4096
KEYLEN 2
KEYOFF 0
ALTKEY ("AA",FILE 0,KEYOFF 0,KEYLEN 2,INSERTIONORDER)
ALTFILE ( 0, $DATAA.DCDTEST.ALT0 )
MAXEXTENTS 16
OWNER 1, 164
SECURITY (RWEP): CUCU
DATA MODIF: 17 Dec 2000, 16:45
CREATION DATE: 17 Dec 1997, 16:45
LAST OPEN: NEVER OPENED
EOF 0 (0.0% USED)
FILE LABEL: 248 (6.1 % USED)
EXTENTS ALLOCATED: 0
INDEX LEVELS: 0

To request detailed information for a Format 2 partitioned SQL/MP table:
-INFO T2, DETAIL
$DATA00.TEST.T2 19 May 2003, 17:08
SQL BASE TABLE
CATALOG $DATA00.TEST
VERSION 350
TYPE K
FORMAT 1
EXT ( 16 PAGES, 64 PAGES, MAXEXTENTS 160 )
REC 46
PACKED REC 46
BLOCK 4096
KEY ( COLUMN 0, OFFSET 0, LENGTH 4, ASC )
PART ( 0, $DATA00, 16 PAGES, 64 PAGES, MAXEXTENTS 160,
FORMAT 1, -2147483648 )
PART ( 1, $D72GB1, 16 PAGES, 64 PAGES, MAXEXTENTS 160,
FORMAT 1, 40 )
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER -1
SECURITY (RWEP): NUNU
DATA MODIF: 19 May 2003, 15:25