Hi,

I am new to DB2 and I am having this one simple query :-

How do I access the two different databases defined in same DB2 Instance using a single query?

e.g.
I have 2 Databases DB2Member and DB2CLaims.
Table Membership in DB2Memeber database and
Table Claim_dtl in DB2Claims database.
Both Databases are running on same DB2 Instance.

Now I wanted to run a query which will get me the Membership info for all
members and Claimdtl info associated with those members.

I suppose SQL would be something like:-
Select A.MemberName, A.MemStatus, B.MemClaimDt, B.MemClaimAmt
From DB2Member.Membership as A, DB2Claims.Claim_dtl as B
Where A.MemID = B.MemID


Now I want to know, how do I do this in DB2?
I have heard of something call federation which allows querying multiple heterogenic databases e.g. Oracle, DB2 etc. Do I have to use this service? If yes , than how?

Thanks a lot in advance for your time and help.

With Cheers,
Rahul

You would need to activate the database for Federated support , and then create alias' and wrappers on one of the databases (where the SQL runs) that references the other database.

See the Federated manual for details or google "db2 federated"

Another option to consider is not using separate databases but rather different schemas.

Database tables are already existing, so restructuring is not an option right now.
I think federation would do the trick for me.
Thanks a lot guys for quick reply.