Re: re-creating .idx file

Kevin P. wrote: > > oops! i hammered an .idx file while trying to "fix" an indexing > problem with one of the tables in my system. yes, i know that > it says practically everywhere in the manuals not to do this, > but i figured if it was hosed already, what could it hurt. so, > while i sit here listening to my multiple tape backup set whir, > i figured i'd also ask the experts. > > the details: > > informix se v4.00 > sco unix v3.2v4 (for what its worth) > > i accidentally deleted the tablename.idx file, although the > tablename.dat file is still there. is there a way to re-create > the .idx?? i have tried CHECK TABLE, REPAIR TABLE, > but no luck. You have to create the file before attempting a repair. If that still doesn't work, then restore the old .idx file then run a repair. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+