Re: Problem with altering tables

> I am getting the following errors when trying to add a > field to certain tables of my database: > > -211 Cannot read system catalog SYSTABLES > and > -111 ISAM error: no record found > > The errors occur from both dbaccess (table - alter) and > the alter table command. > > I am running Online 5.02 UC6 on a Sun Sparc 20 (SunOS 5.3). > . . > Thanks > Ron Desjardins > (rond@ftp.com) I had the same problems with version 5.02 UC12 and could fix it. I think, the problem is caused from a long transaction of an alter table statement. If you run an alter table and get a long transaction, then the DBS makes a mistake and leave a temp-row back in the table systables. This row has then tabname "lot of spaces", so the table cannot be selected or usually created. You can find this row with indexes, which are at the table. If you unload the concerning table and drop it, then you can search one of the indexes in the table sysindexes. So you get the tabid of the row in the table systables. If you run a select on this table, you can get the corrupted row. Delete this row and all appropriate rows in the tables syscolumns , sysindexes and so on. After you have deleted this rows, you can perform alter-Statements. I hope that helps and was clear and concise enough. heimo #******************************************************************************* Heimo Bergler c/o Softline Ges mbH. Ungerdorf 116 A-8200 Gleisdorf Tel. : 03112/3304 EMail.: heimo@softline.co.at