Existing table can not be found
Posted in 2009
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.