Fox 12:listf text@,2 WED, FEB 21, 2007, 11:03 AM ACCOUNT= KEVENM GROUP= DB FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE---- SIZE TYP EOF LIMIT R/B SECTORS #X MX TEXT PRIV 128W FB 6 6 1 16 1 1 TEXT01 PRIV 512W FB 3 3 1 16 1 1 TEXT02 PRIV 512W FB 6 6 1 32 1 1 TEXT03 PRIV 512W FB 10 10 1 48 1 1 TEXTSC 80B FA 34 34 3 16 1 1 Fox 12:imagesql HP36385B B.G2.15 IMAGE/SQL Utility WED, FEB 21, 2007, 11:04 AM (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993 >>dbe textdbe DBE does not exist, do you want to create one? [Y/N] : y Creating DBE now ... >> >>base text >>attach Mapped 6 source table/source field name(s) (ATCWARN 32062). >>display base tables DBEnvironment : TEXTDBE.DB.KEVENM BASE FILE OWNER MAPPED TABLE --------- ----- ------------ TEXT.DB.KEVENM TEXT SEQNO PRODUCT_DESC TEXT_LINES Total Databases : 1 >>display users ATTACHED BASES : TEXT.DB.KEVENM DBEnvironment : TEXTDBE.DB.KEVENM Owner Name : TEXT USER LOGON DBOPEN MODE USER PASSWORD USER CLASS ---------- ----------- ------------- ---------- MGR.KEVENM 5 ; 64 >>exit Fox 12: Fox 12: Fox 12:ISQL IIIIIIII SSSSSSSS QQQQQQQ LL II SS QQ QQ LL II SS QQ QQ LL II SSSSSS QQ QQ LL II SS QQ Q QQ LL II SS QQ QQ LL IIIIIIII SSSSSSS QQQQQQ QQ LLLLLLLLL WED, FEB 21, 2007, 11:05 AM HP36216-02A.G3.22 Interactive SQL/3000 ALLBASE/SQL (C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988, 1989,1990,1991,1992,1993,1994. ALL RIGHTS RESERVED. isql=> connect to 'TEXTDBE'; isql=> select * from text.seqno; select * from text.seqno; ----------- TXT_SEQNO ----------- 1 2 3 --------------------------------------------------------------------------- Number of rows selected is 3 U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] , or e[nd] > e isql=>exit; A transaction is in progress. Commit work (Y/N)> y Fox 12: Fox 12: Fox 12: Fox 12:listf text@,2 WED, FEB 21, 2007, 11:06 AM ACCOUNT= KEVENM GROUP= DB FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE---- SIZE TYP EOF LIMIT R/B SECTORS #X MX TEXT PRIV 128W FB 6 6 1 16 1 1 TEXT01 PRIV 512W FB 3 3 1 16 1 1 TEXT02 PRIV 512W FB 6 6 1 32 1 1 TEXT03 PRIV 512W FB 10 10 1 48 1 1 TEXTDBCR PRIV 2048W FB 128 131072 1 256 1 * TEXTDBE PRIV 2048W FB 3 11 1 48 1 * TEXTDBFL PRIV 2048W FB 5000 5000 1 80000 1 32 TEXTDBLG PRIV 256W FB 10000 10000 1 20000 1 32 TEXTSC 80B FA 34 34 3 16 1 1 TEXTTC PRIV 28W FB 1 1023 4 208 1 * Fox 12:sqlutil WED, FEB 21, 2007, 11:06 AM HP36216-02A.G3.22 DBE Utility/3000 ALLBASE/SQL (C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988, 1989,1990,1991,1992,1993,1994. ALL RIGHTS RESERVED. >> purgeall DBEnvironment Name: textdbe Purge DBEnvironment and Log Files (y/n)? y DBEnvironment and Log Files purged. >> exit Fox 12:listf text@,2 WED, FEB 21, 2007, 11:07 AM ACCOUNT= KEVENM GROUP= DB FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE---- SIZE TYP EOF LIMIT R/B SECTORS #X MX TEXT PRIV 128W FB 6 6 1 16 1 1 TEXT01 PRIV 512W FB 3 3 1 16 1 1 TEXT02 PRIV 512W FB 6 6 1 32 1 1 TEXT03 PRIV 512W FB 10 10 1 48 1 1 TEXTSC 80B FA 34 34 3 16 1 1 Fox 12: