Re: Existing table can not be found

Yes, IDS maps all object names to lower case (unlike SQL Server and Access). Set DELIMIDENT=1 and export it in the environment then do: drop table "BA_wco_ea"; -- quotes required. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 29, 2009 at 6:30 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de> wrote: > Hi all, > > IDS 7.31.UD1X4, I know, very old version. > > Somebody created a tables in an informix database by using the export > function of MS Access via Sequelink ODBC (didn't even know, that it was > possible). With MS Access the table can be accessed, the content can be > read. > > With dbaccess you see the table in the Table-Info menu, you can also see > the > columns. If you choose Status an error message appears: > > 206: The specified table (owner.ba_wco_ea) is not in the database. > 111: ISAM error: no record found.> > I tried to drop the table, no success, same error as above. > > I checked syscatolog, no errors. I also had a look to > sysmaster:systabnames. > The table is present. > > What's wrong? I would be happy if at least I could drop the tables. > > Uups: Last minute finding: The table name is "BA_wco_ea" but in the error > message the are no capitals. Could that be the reason? > > TIA. > Reinhard. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >