Re: accessing AS400 data in Oracle

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 6 Jan 2005 22:29:55 +0100
Message-ID: <41ddadd6$0$2767$ba620e4c@news.skynet.be>

<andrzeju_at_yahoo.com> wrote in message
news:1105023866.601325.23650_at_f14g2000cwb.googlegroups.com...
> I'm trying to access data from AS400 using gateway.
> e.g. SELECT * FROM LIB.FILE2_at_AS400
> It works for some tables only. All tables are from the same library and
> have all privilages granted to Oracle. I just guess that it does not
> work for the tables that were added on the AS400 recently but I'm not
> sure. I've never used gateway before.
>
> The error I'm getting is the following:
> ORA-0942:tableor view does not exist
> ORA-02063:preceding line from AS400
>
> Of course I checked AS400. The table exists.
> Any help is greatly appreciated.
> Thanks
> Andrzej Urbanowicz
>

Are the table names case sensitive ? Just an idea, I don't know AS400 ... Received on Thu Jan 06 2005 - 15:29:55 CST