Can't delete table ... errors 211/111
Posted in 1996
Hi,
Informix SE 7.10.UC2, 4GL 6.02.UC1
I've got a table that I can't delete anything from anymore.
When I do this in dbaccess:
delete from timesum_current where 1=1
The errors I get are:
211: Cannot read system catalog (systables).
111: ISAM error: no record found.
I've run: check table in dbaccess and both timesum_current and systables
come up fine ...
I've also run: secheck on every table in that database and they all come
up fine.
I can't drop the table (from dbaccess), I can't alter it ...
I can query it, no problem but I can't update any of the rows or delete
any of them.
When I try to alter the table using the menu commands in dbacess, I get a
slightly different error:
ISAM error: duplicate value for a record with a unique key.
I've checked the keys, though and don't see any duplicates...
Any ideas?
Thanks
MArc
marc@pamco.com