Re: re-creating .idx file

"Kevin P." <kpavlish@themailroom.com> 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. Excuse me, but can't you just "touch <filename>.idx" and then run a bcheck -s? Since the bcheck -s doesn't even *try* to read the existing .idx (it just renames it to *.IDX) that *should* do it. >please e-mail response to me. >kpavlish@themailroom.com >thanks >-k