I have a corrupt database table and tried to use the quick fix option but it had no effect. The other options are rather confusing, can you tell me how to issue a command line argument to kdbfchk that will fix a table?
After I do the above, I still get a message like the following (BTW I have already dropped all indexes on this table):
005 Bad size 0 for column FILEID at offset 0xC in recid 0x51DED2 of e:\data2\AUD
IT.tbl in the function fbuftofld
100 Error in data, file e:\data2\AUDIT.tbl, offset 0x51DED2
That sounds as if that record has some bad data in it. Kdbfchk checks the structure of the file, not the contents. You may need to make a copy of the file, e.g.
create table NAUDIT as select * from AUDIT;
It will detect the error, and not copy that row, but will go on to read and process subsequent rows.