Re: Lost INDEX files
Posted in 1996
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
> > Hi, > > I recently had a problem when 5 or 6 tracks on the hard disk went bad. > The result was several index files (*.idx) disapeared. Is there any way to > rebuild the index files from the data files (*.dat). I copied an old index > file to replace the missing one. Although file status reported 150 rows for > one file; presumably from systables, running bcheck with the -s option > did not recreate the 150 rows. > > I am using I4GL 4.0 on SCO Unix. > I mean you are using SE - what you have done is correct. Maybe you '.dat' file is broken too. Check the number of records: wc -l file.dat You will get the number of records ( = lines). Then build a new '.idx' file via 'bcheck -s file'. Last message line from bcheck reports: x index node(s) used, y free -- zzz data record(s) used, ? free. If this two numbers are identical, your new '.idx' file should be fine. If not, I would imagine that the '.dat' file is faulty. -- Chris Drauch ...................................................................... . c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 . . Gewerbestrasse 5 Fax 43/ 3135/4638728 . . A-8071 Hausmannstaetten EMail cdr@xteam.co.at . ......................................................................