Matthias Hoys wrote:
> <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
...
The tables are case sensitive but I compared names. They are identical.
Received on Fri Jan 07 2005 - 09:14:07 CST
