Repairing A table

Posted in 2000

Tanak.Jacobs@icl.com — Wed, 6 Dec 2000 07:15:51 -0000 — source: Informix-list mailing list archive (1991-1998)

Does anyone out there know how to repair a table , using the follwoing commands , bcheck or oncheck ? Rgds Tanak

↪ replying to Tanak.Jacobs@icl.com

Jonathan Leffler — Wed, 06 Dec 2000 23:25:22 GMT — source: Informix-list mailing list archive (1991-1998)

Tanak.Jacobs@icl.com wrote: > Does anyone out there know how to repair a table, using the follwoing > commands, bcheck or oncheck? Are you using SE or OnLine? If you're using SE, use bcheck (or secheck); oncheck won't help at all. Either use DB-Access and 'repair table tablename' or simply run bcheck on the C-ISAM file that contains the table to be repaired. This is roughly what Robert Stuart told you, too. If you're using OnLine, then neither bcheck nor secheck is any use and only oncheck can assist. You would need to look at the manual to find the options to use (mainly because I'm too lazy to go to the manual and find them for you!). In case of doubt, the manuals can be downloaded from http://www.informix.com/answers/. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"