t you can use thMASK DBF MAST CMDMAST DBFMASTDBF DOC8ÿ*******************************ÿ*******************************ÿ**** *************************,FNAMEC ÑlDISKC ÝlFILECélTYPECñlDSKCôlNUMC÷lSQUCúl ++++0k.FRE CFOGLIB.002 ++++0k FRECFO002 *++++0k.FRE OGGLIB.002 ++++0k FREOGG002 *++++2k.FRE CFOGLIB.001 ++++2k FRECFO001 *++++6k.FRE OGGLIB.093 ++++6k FREOGG093 *+++12k.FRE OGGLIB.025 +++12k FREOGG025 *+++16k.FRE CFOGLIB.025 +++16k FRECFO025 *+++16k.FRE OGGLIB.095 +++16k FREOGG095 *+++18k.FRE OGGLIB.094 +++18k FREOGG094 *+++22k.FRE CFOGLIB.000 +++22k FRECFO000 *+++22k.FRE OGGLIB.000 +++22k FREOGG000 *+++24k.FRE OGGLIB.091 +++24k FREOGG091 *+++30k.FRE OGGLIB.--- +++30k FREOGG--- *+++30k.FRE OGGLIB.092 +++30k FREOGG092 */.COM CFOGLIB.001 / COMCFO001 *ASCII.BAS CFOGLIB.002 ASCII BASCFO002 *ASCII.BAS OGGLIB.002 ASCII BASOGG002 *BSORT.COM CFOGLIB.001 BSORT COMCFO001 *CAT.COM CFOGLIB.001 CAT COMCFO001 *CAT2.COM CFOGLIB.001 CAT2 COMCFO001 CAT2.COM CFOGLIB.001 EOGG094 0*+++16k FREOGG095 0************************************************** * DBII COMMAND FILE: * PROGRAM TO PUT MAST.CAT INTO MAST.DBF * AUTHOR: HERBART RUITENBERG DEN HAAG NETHERLANDS * FILES MASTDBF.DOC MAST.CMD MAST.DBF AND MASK.DBF * BELONG TOGETHER * INDEX MAST.NDX WILL BE PRODUCED ************************************************** ERASE ? "GET MAST.CAT INTO MAST.DBF" ? "--------------------------" ? "FILES NEEDED:" ? " MAST.CAT (DATA)" ? " MASK.DBF (STRUCTURE TO RECEIVE DATA)" ? " MAST.DBF (STRUCTURE FOR FINAL DATA)" ? "TAKE CARE:" ? "ALL RECORDS IN MASK.DBF AND MAST.DBF WILL BE DELETED." ? "COPY ANY VALUABLE MAST.DBF BEFORE " ? " RUNNING THIS PROGRAM." ? "READY? TO STOP" WAIT SET TALK OFF ERASE ? "OFF WE GO...." USE MAST DELETE ALL PACK USE MASK COPY TO TEMP USE TEMP ? "MAST EMPTIED, TEMP CREATED. STOP? (THEN )" WAIT ? "DATA FROM MAST.CAT INTO TEMP" APPEND FROM MAST.CAT DELIMITED DELETE RECORD 1 PACK ? "DATA IN TEMP, FIRST RECORD (DUMMY) OUT" ? "DATA ANALYSIS" REPL ALL FILE WITH $(FNAME,1,@([.],FNAME)-1) REPL ALL TYPE WITH $(FNAME,@([.],FNAME)+1,@([.],FNAME)+3) REPL ALL DSK WITH $(DISK,1,3) , NUM WITH $(DISK,@([.],DISK)+1,@([.],DISK)+3) REPL ALL SQU WITH "SQ" FOR $(TYPE,2,1)="Q" ? "DATA ANALYSIS READY. PUT THEM IN MAST.DBF" USE MAST APPEND FROM TEMP DELETE FILE TEMP ? "DATA IN MAST. INDEX ON DISK AND DISKNUMBER" INDEX ON DSK + NUM TO MAST ? "INDEXING READY." SET TALK ON ERASE ? "READY. RESULT IN MAST.DBF" ? " " ? "MAKE COPY OF MAST.DBF UNDER A DIFFERENT NAME:" ? "NEXT RUN OF THIS PROGRAM ONLY CONSERVES " ? "STRUCTURE OF MAST.DBF" ? " " ? "MAST IS INDEXED: USE MAST INDEX MAST" RETURN ‡FILECÑlTYPECÙlDSKCÜlNUMCßlSQUCâl CPBLIB 007CPB005 % CALCPB003 ++++0k FRECPB005 ++++0k FRECPB008 ++++2k FRECPB007 ++++6k FRECPB001 ++++8k FRECPB010 +++12k FRECPB003 +++14k FRECPB009 +++16k FRECPB011 +++24k FRECPB002 +++36k FRECPB004 +++60k FRECPB006 @ COMCPB004 @ COMCPB007 AVOREEKSCALCPB003 BAS COMCPB001 BRJ2M CALCPB011 BRJ2V CALCPB011 BRJAVOM CALCPB002 BRJAVOV CALCPB002 BRJM CALCPB003 BRJM2 CALCPB003 BRJV CALCPB003 BRJV2 CALCPB003 COMGEB TXTCPB010 COMKOST TXTCPB005 COMKOST TXTCPB007 COP COMCPB004 COP COMCPB011 CP/M CATCPB004 CP/M CATCPB007 CPBSVL TXTCPB010 DEFGES CALCPB009 DEFJAR CALCPB009 DEFLFT CALCPB009 DEFNIV CALCPB009 DEFREG CALCPB009 DEFSCH CALCPB009 EFFB TQTCPB010SQ GLOM CALCPB001 GLOM CALCPB003 GLOM81 CALCPB002 GLOV CALCPB003 GLOV81 CALCPB002 HARK CALCPB009 HARK1 QQQCPB008SQ HARK2 QQQCPB008SQ HARK3 QQQCPB008SQ HAVOM CALCPB003 HAVOM2 CALCPB003 HAVOV CALCPB003 HAVOV2 CALCPB003 IV18 QQQCPB008SQ IV19 QQQCPB008SQ KMBOM CALCPB009 KMBOV CALCPB009 KMBOV PRNCPB005 KOST CALCPB009 KT CALCPB009 LFTM CALCPB005 LFTV CALCPB005 LFTVGLM CALCPB005 MAST BAKCPB005 MAST CATCPB001 MAST CATCPB007 MAVO4M CALCPB002 MAVO4MB CALCPB002 MAVO4MD CALCPB002 MAVO4V CALCPB002 MAVO4VB CALCPB002 MAVO4VD CALCPB002 MIDDEN CPB010 MIG80 CALCPB004 NEW CATCPB005 NEWCAT COMCPB001 NEWCAT COMCPB007 OP COMCPB001 OP COMCPB002 OP COMCPB003 OP COMCPB006 OP COMCPB008 OP COMCPB009 OP COMCPB010 OW2209 TXTCPB010 PERCENT CALCPB003 PIP COMCPB001 PIP COMCPB006 PIP COMCPB007 PIP COMCPB008 PIP COMCPB009 PIP COMCPB010 PUTCAT COMCPB005 PUTCAT COMCPB007 REEKS CALCPB011 REGOND TXTCPB010 ROOS BASCPB001 RRM CALCPB002 RRM0 CALCPB004 RRM1 CALCPB011 RRV0 CALCPB004 RRV1 CALCPB011 RVDB1182TQTCPB008SQ SCP TQTCPB010SQ SKILL CPB005 SKILLTABTQTCPB010SQ SPEC CALCPB009 SQ COMCPB007 STUF01M DATCPB006 STUF01V DATCPB006 STUF04M DATCPB006 STUF04V DATCPB006 STUF08M DATCPB006 STUF09M DATCPB006 STUF11M DATCPB006 STUF13M DATCPB006 STUF17M DATCPB006 STUF17V DATCPB006 STUFLO TXTCPB007 SV TQTCPB008SQ SV TQTCPB010SQ SVDEF CALCPB009 SVL CALCPB005 SVOVER CALCPB009 TYPSQ COMCPB007 USQ COMCPB007 VOORLMBOCALCPB005 VWOM CALCPB003 VWOV CALCPB003 WILLEMSZ CPB010 XDIR COMCPB001 XDIR COMCPB007 XDIR COMCPB008 XDIR COMCPB009 Y CALCPB003 MIG80.CAL CPBLIB.004 MIG80 CALCPB004 NEW.CAT CPBLIB.005 NEW CATCPB005 NEWCAT.COM CPBLIB.001 NEWCAT COMCPB001 NEWCAT.COM CPBLIB.007 NEWCAT COMCPB007 OP.COM CPBLIB.001 OP COMCPB001 OP.COM CPBLIB.002 OP COMCPB002 OP.COM CPBLIB.003 OP COMCPB003 OP.COM CPBLIB.006 OP COMCPB006 OP.COM Herbarô Ruitenberg Dutcè Osbornå Group postbuó 84151 250¸ AÄ Deî Haag Netherlands 2° Januarù 1983 CHANGINÇ MAST.CAÔ INTÏ Á dBIÉ FILE® Publiã domaiî softwarå likå NEWCAÔ anä PUTCAÔ enableó easù � catalogueinç oæ fileó oî diskó iæ diskó arå markeä witè thå namå oæ á � librarù anä thå numbeò iî thå library. PUTCAÔ produceó alpabeticallù sorteä output® Iô may¬ however¬ bå � usefuì tï selecô oî otheò aspectó oæ thå files® Alì Basic-fileó mighô � bå listed¬ alì squeezeä fileó (witè Ñ iî thå seconä placå oæ type-� name© oò alì document-files. dBIÉ allowó alì necessarù analysió oæ á databaså witè thå datá oæ thå � fileó involved® Thå waù tï dï iô ió describeä here® Thå fileó � necessarù gï witè thió DOC-file. Conditions ---------- Beforå startinç fouò fileó neeä tï bå present® Theù are: 1® Commandfilå MAST.CMÄ (thå program) 2® Datá iî MAST.CAÔ (oæ course) 3® MASK.DBÆ anä 4® MAST.DBF® Thå latteò twï fileó arå emptù databaså files¬ theù onlù consisô oæ á � structurå tï receivå data. MASK.DBÆ giveó thå structurå foò acceptinç thå filenamå anä thå � identificatioî oæ thå disë oî whicè thå filå ió resident® Alì fieldó � arå character-fields. FNAMÅ 1² char. DISË 1² char. FILÅ ¸ char. TYPÅ ³ char. DSË ¸ char. NUÍ ³ char. SQÕ ² char. FNAMÅ receiveó thå filename/typå anä DISË diskname/numbeò froí � MAST.CAÔ ® Bù analysió oæ FNAMÅ thå fieldó FILÅ anä TYPÅ arå filled.� DISK provides data for thå fieldó DSË anä NUÍ. SQÕ ió filleä witè "SQ¢ iæ thå seconä characteò oæ TYÐE ió á "Q"¬ � referrinç tï á squeezeä file. MAST.DBÆ ió thå finaì result® Iô haó thå samå structurå anä contentó � aó MASK.DBF¬ excepô thaô thå fieldó FNAMÅ anä DISË arå lefô out® Thió �Šió donå tï reducå thå sizå oæ thió file.Useró may¬ oæ course¬ expanä � MAST.DBF® MASK.DBÆ ió onlù temporarilù needeä foò appendinç recordó froí � MAST.CAT® Becauså thå structurå oæ MASË shoulä bå permanentlù presenô � MASË ió copieä tï TEMÐ aô thå starô oæ thå program® Aó sooî aó datá � havå beeî appendeä tï MASÔ froí TEMÐ thå latteò ió deleted® Thuó � diskspacå ió saved. Runninç thå program. -------------------- Thå procedurå ió quitå easy: Starô dBII SEÔ DEFAULÔ TÏ B DÏ MAST Thå prograí askó twï questions. First¬ whetheò thå necessarù inputfileó arå present® (Á lisô ió � given.© Thió questioî cautionó thaô filå MASÔ wilì bå emptieä iæ thå prograí � ió alloweä tï ruî further® Thå structurå oæ MASÔ ió needeä tï receivå � datá froí TEMP® Iæ MASÔ haó tï bå saveä first¬ bù COPYing¬ theî presó �