Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Informix  »  Existing table can not be found...
Page 1 of 1    

Existing table can not be found...
Author Message
Habichtsberg, Reinhard...
Posted: Thu Oct 29, 2009 2:30 pm
Guest
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.
Back to top  
Habichtsberg, Reinhard...
Posted: Thu Oct 29, 2009 3:16 pm
Guest
Quote:
From: Reinhard

....

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?

Sorry to bother you. Yes, the issue was the capital letters in the field
tabname of systables. I updated that field to lowercase the problem
vanished.

Thanks, Reinhard.
Back to top  
Art Kagel...
Posted: Thu Oct 29, 2009 5:33 pm
Guest
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 at (no spam) 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 at (no spam) arz-emmendingen.de> wrote:

Quote:
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 at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Back to top  
 
    Display posts from previous:  
Page 1 of 1    
All times are GMT
The time now is Thu Nov 26, 2009 9:58 pm
Computers Forum Index
 

Powered by phpBB & ML | Privacy Policy / Disclaimer



Contact Us