Rommel,
Distributed database access is possible only through something called a "federated
database" (Data Joiner integrated into DB2 UDB). To use this feature, you have to do
the following.
a) Create wrappers for the appropriate DB module. In your case DRDA using the
CREATE WRAPPER syntax.
b) Create server mappings for all databases you want to access using the following
syntax
create server SERVER_NAME type db2/udb version 7.1 wrapper DRDA
authorization....
c) Create user mappings for all users ..
create user mapping for USER_NAME server SERVER_NAME options ....
d) Create nicknames for all the tables that you want to access
create nickname SCHEMA.TABLENAME for REMOTE_SCHEMA.REMOTE_TABLE ....
There is a caveat though, make sure you have the default USERSPACE1 tablespace
before you create the nicknames (this is a bug).
Regards,
Ajith
-----Original Message-----
From: Erwin Rommel Ganaban [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 4:21 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Two databases
Hi,
I am doing migration of database from sql server to DB2, i had finished the
importation of data.. and right now I am creating a views for each database i
imported.. The question is, I have a view in a database accessing table from the other
database.. I cant create a view, i tried all the qualifiers from the "FROM" statement
but still, not succesful.
If somebody knows the solution about this problem, please give me some feedback..
and i am very greatful for your help.
thank you..
Rommel Ganaban - SEIYU Singapore
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
