re-creating .idx file

Posted in 1996

Kevin P. — 27 Dec 1996 16:06:58 GMT — source: Informix-list mailing list archive (1991-1998)

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. please e-mail response to me. kpavlish@themailroom.com thanks -k