Hi. We have almost all our tables defined on library lib1 and some on
lib2. We have alias defined on lib1 to access tables on lib2 so there
is no need to qualify library name. Alias for tables on lib2 are
defined this way:
CREATE ALIAS lib1.table1 FOR lib2.table1;
Both table owner and alias owner is the same. Tables reside on a
AS/400 server and we are accesing database from a DB2 client on a PC
workstation (DB2 is version 7)
When we try to access one of these tables (for example select * from
table1) we get error
SQL0204N "OWNER .TABLE1" is an undefined name. SQLSTATE=42704
Where OWNER is the name of the table/alias owner.
We have no problem if we qualify the library name where alias is
defined (select * from lib1.table1). There is no need to qualify
library name for tables on lib1.
Any ideas?
Thanks in advance.