Re: Can't delete table ... errors 211/111

Marc Kneppers wrote: > > 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 Did you try checking the system catalogue tables? It sounds like a problem with one of those, probably systables :-( Ian