submit query in two different subsystems



IBM's flagship relational database management system

submit query in two different subsystems

Postby manojlives » Tue Dec 30, 2008 2:45 pm

HI i need to submit query in two different subsystems using IKJEFT01.
is it possible?


for eg:
select * from db2e.----------;

select * from db2c.----------;
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: submit query in two different subsystems

 

Re: submit query in two different subsystems

Postby dick scherrer » Thu Jan 01, 2009 11:21 am

Hello,

This falls into the realm of DRDA ( distributed relational database access ).

One way to access data in a different subsystem by using remote aliases.

Info in the DB2 iInstallaton Guide may be useful.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post