v7 joins accorss multi subsystems

Sherri Sterling

v7 joins accorss multi subsystems
We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling



Sibimon Philip

Re: v7 joins accorss multi subsystems
(in response to Sherri Sterling)
"Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability."

You can do this in Microsoft SQLserver with our any problem. You can create
a link server and join any table in any server. We use it a lot.

Thanks..sibi


-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 08:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling








Inc. The Fillmore Group

Re: v7 joins accorss multi subsystems
(in response to Sibimon Philip)

Sherri,
One solution is to install DataJoiner or use the Relational Connect feature of DB2 UDB to access multiple DB2 databases in a single SQL statement. DJ
and RC are typically used to access heterogeneous databases, in your case it's all DB2 and those products essentially don't care. I know you would
probably prefer to keep everything on the host; although DJ is not yet supported on Linux, DB2 UDB (with Relational Connect) runs on Linux for zSeries.
You can set up a Linux LPAR on your zSeries hardware and have that serve as the front-end for your queries to multiple databases. This roughly
approximates the functionality of DRDA Distributed Request.

Let me know if you need more details.

HTH,
Frank


On Fri, 6 Dec 2002 09:59:20 -0500, Sherri Sterling DIGEST NOMIME wrote:

>We are at the same delima. We even have data sharing groups and still
>cannot join two different tables from two subsystems within the same sql.
>We have to select one and use a global temp table and select from the
>other one and manipulate the global temp tables. Here is a good white
>paper from Craig Mullens on this subject,
>www.dbazine.com/mullins_drda.html
>
>A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
>statements to read and/or modify multiple RDBMSs within a single unit of
>work. However, only one RDBMS can be specified per SQL statement.
>
>Distributed Request enables this above feature, however there are no RDBMS
>products that currently provide DRDA distributed request capability.
>
>Sherri Sterling
>
>
>



+-------------------------------------+--------------------------------------+
| Frank C. Fillmore, Jr. | Voice/Fax: 410.465.6335 |
| The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs |
| 3213-A Corporate Court | E-mail: [login to unmask email] |
| Ellicott City, Maryland 21042-2247 | URL: http://www.thefillmoregroup.com |
| USA | |
+-------------------------------------+--------------------------------------+
| DB2 Family, Oracle, Client/Server, Distributed Database |
| "Relational Database Solutions"(sm) |
+----------------------------------------------------------------------------+

Steve (SCH) Barth

Re: v7 joins accorss multi subsystems
(in response to Inc. The Fillmore Group)
Thanks. I had thought that data sharing would enable you to do that, since
everything is in a common catalog. Looks like I'm wrong again, darnit!

-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 9:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling








Michael Ebert

Re: v7 joins accorss multi subsystems
(in response to Steve (SCH) Barth)
There seems to be some confusion. Data Sharing essentially lets you add
machines (nodes) to your subsytem (RDBMS) to increase processing power and
availability. But it's still one subsystem (one catalog/directory in one
location), so there is no question of accessing data across subsystems.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




Thanks. I had thought that data sharing would enable you to do that, since
everything is in a common catalog. Looks like I'm wrong again, darnit!

-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 9:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling

Leon Katsnelson

Re: v7 joins accorss multi subsystems
(in response to Michael Ebert)
DB2 Connect V7.2 and later allows you to join tables from multiple
subsystems. In version 8 we added capability to do a distributed UPDATE,
DELETE and INSERT. So, yes, you can do a SELECT ... FROM t1, t2 and have
t1 and t2 reside on separate subsystems. This capability is not limited to
simply multiple tables on a SELECT, you can have a SELECT with a subselect
from another subsystem etc.

Leon Katsnelson
Manager, DB2 Product Planning
Administration Assistant: Robin Stockfish (905) 413-3632


|---------+---------------------------->
| | "Philip, Sibimon"|
| | <[login to unmask email]|
| | .COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | LASSOC.COM> |
| | |
| | |
| | 12/06/2002 10:24 |
| | AM |
| | Please respond to|
| | DB2 Data Base |
| | Discussion List |
| | |
|---------+---------------------------->
>-------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| Subject: Re: v7 joins accorss multi subsystems |
| |
| |
>-------------------------------------------------------------------------------------------------------------------------------------|



"Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability."

You can do this in Microsoft SQLserver with our any problem. You can create
a link server and join any table in any server. We use it a lot.

Thanks..sibi


-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 08:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling



the





the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



Steve (SCH) Barth

Re: v7 joins accorss multi subsystems
(in response to Leon Katsnelson)
Leon,

The applications using these subsystems are traditional COBOL/DB2 OS/390
programs using cursor selects.

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Monday, December 09, 2002 8:43 AM
To: [login to unmask email]
Subject: Re: v7 joins accorss multi subsystems


DB2 Connect V7.2 and later allows you to join tables from multiple
subsystems. In version 8 we added capability to do a distributed UPDATE,
DELETE and INSERT. So, yes, you can do a SELECT ... FROM t1, t2 and have
t1 and t2 reside on separate subsystems. This capability is not limited to
simply multiple tables on a SELECT, you can have a SELECT with a subselect
from another subsystem etc.

Leon Katsnelson
Manager, DB2 Product Planning
Administration Assistant: Robin Stockfish (905) 413-3632


|---------+---------------------------->
| | "Philip, Sibimon"|
| | <[login to unmask email]|
| | .COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | LASSOC.COM> |
| | |
| | |
| | 12/06/2002 10:24 |
| | AM |
| | Please respond to|
| | DB2 Data Base |
| | Discussion List |
| | |
|---------+---------------------------->

>---------------------------------------------------------------------------
----------------------------------------------------------|
|
|
| To: [login to unmask email]
|
| cc:
|
| Subject: Re: v7 joins accorss multi subsystems
|
|
|
|
|

>---------------------------------------------------------------------------
----------------------------------------------------------|



"Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability."

You can do this in Microsoft SQLserver with our any problem. You can create
a link server and join any table in any server. We use it a lot.

Thanks..sibi


-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 08:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling



the





the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can








Myron Miller

Re: v7 joins accorss multi subsystems
(in response to Steve (SCH) Barth)
Actually, if you're willing to setup up aliases pointing to the other
subsystems tables, you can do the multiple system join now even with V6 of DB2.
My client has one application that is doing that currently and is accessing
the tables both with COBOL CICS programs and with VB distributed programs.

Myron
--- "Barth, Steve (SCH)" <[login to unmask email]> wrote:
> Leon,
>
> The applications using these subsystems are traditional COBOL/DB2 OS/390
> programs using cursor selects.
>
> -----Original Message-----
> From: [login to unmask email] [mailto:[login to unmask email]
> Sent: Monday, December 09, 2002 8:43 AM
> To: [login to unmask email]
> Subject: Re: v7 joins accorss multi subsystems
>
>
> DB2 Connect V7.2 and later allows you to join tables from multiple
> subsystems. In version 8 we added capability to do a distributed UPDATE,
> DELETE and INSERT. So, yes, you can do a SELECT ... FROM t1, t2 and have
> t1 and t2 reside on separate subsystems. This capability is not limited to
> simply multiple tables on a SELECT, you can have a SELECT with a subselect
> from another subsystem etc.
>
> Leon Katsnelson
> Manager, DB2 Product Planning
> Administration Assistant: Robin Stockfish (905) 413-3632
>
>
> |---------+---------------------------->
> | | "Philip, Sibimon"|
> | | <[login to unmask email]|
> | | .COM> |
> | | Sent by: DB2 Data|
> | | Base Discussion |
> | | List |
> | | <[login to unmask email]|
> | | LASSOC.COM> |
> | | |
> | | |
> | | 12/06/2002 10:24 |
> | | AM |
> | | Please respond to|
> | | DB2 Data Base |
> | | Discussion List |
> | | |
> |---------+---------------------------->
>
> >---------------------------------------------------------------------------
> ----------------------------------------------------------|
> |
> |
> | To: [login to unmask email]
> |
> | cc:
> |
> | Subject: Re: v7 joins accorss multi subsystems
> |
> |
> |
> |
> |
>
> >---------------------------------------------------------------------------
> ----------------------------------------------------------|
>
>
>
> "Distributed Request enables this above feature, however there are no RDBMS
> products that currently provide DRDA distributed request capability."
>
> You can do this in Microsoft SQLserver with our any problem. You can create
> a link server and join any table in any server. We use it a lot.
>
> Thanks..sibi
>
>
> -----Original Message-----
> From: Sherri Sterling DIGEST NOMIME
> [mailto:[login to unmask email]
> Sent: Friday, December 06, 2002 08:59 AM
> To: [login to unmask email]
> Subject: v7 joins accorss multi subsystems
>
>
> We are at the same delima. We even have data sharing groups and still
> cannot join two different tables from two subsystems within the same sql.
> We have to select one and use a global temp table and select from the
> other one and manipulate the global temp tables. Here is a good white
> paper from Craig Mullens on this subject,
> www.dbazine.com/mullins_drda.html
>
> A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
> statements to read and/or modify multiple RDBMSs within a single unit of
> work. However, only one RDBMS can be specified per SQL statement.
>
> Distributed Request enables this above feature, however there are no RDBMS
> products that currently provide DRDA distributed request capability.
>
> Sherri Sterling
>
>
>
> the
>
>
>
>
>
> the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
> can
>
>
>
>
>
>
>
>
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



Grace Chen

Re: v7 joins accorss multi subsystems
(in response to Myron Miller)
Hi! Leon,
I have DB2 Connect 7.2 installed on my PC and I was trying to run following
select statement to join two tables from two DB2 subsystems. I was running
it from Command Center.
select * from cucddb2.sysibm.systables a,cucddb22.sysibm.systables b where
a.creator=b.creator;
I got SQL error code -512 which means I select two tables from different
subsystem.
I am wondering where you ran the select statement, Command Center, command
Line Processor or control Center?

Grace
-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Monday, December 09, 2002 6:43 AM
To: [login to unmask email]
Subject: Re: v7 joins accorss multi subsystems


DB2 Connect V7.2 and later allows you to join tables from multiple
subsystems. In version 8 we added capability to do a distributed UPDATE,
DELETE and INSERT. So, yes, you can do a SELECT ... FROM t1, t2 and have
t1 and t2 reside on separate subsystems. This capability is not limited to
simply multiple tables on a SELECT, you can have a SELECT with a subselect
from another subsystem etc.

Leon Katsnelson
Manager, DB2 Product Planning
Administration Assistant: Robin Stockfish (905) 413-3632


|---------+---------------------------->
| | "Philip, Sibimon"|
| | <[login to unmask email]|
| | .COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | LASSOC.COM> |
| | |
| | |
| | 12/06/2002 10:24 |
| | AM |
| | Please respond to|
| | DB2 Data Base |
| | Discussion List |
| | |
|---------+---------------------------->

>---------------------------------------------------------------------------
----------------------------------------------------------|
|
|
| To: [login to unmask email]
|
| cc:
|
| Subject: Re: v7 joins accorss multi subsystems
|
|
|
|
|

>---------------------------------------------------------------------------
----------------------------------------------------------|



"Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability."

You can do this in Microsoft SQLserver with our any problem. You can create
a link server and join any table in any server. We use it a lot.

Thanks..sibi


-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 08:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling



the





the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can







**************************************************************************************************
The contents of this email and any attachments are confidential.
It is intended for the named recipient(s) only.
If you have received this email in error please notify the system manager or the
sender immediately and do not disclose the contents to any one or make copies.

** eSafe scanned this email for viruses, vandals and malicious content **
**************************************************************************************************



HEPP SHERY C

Re: v7 joins accorss multi subsystems
(in response to Grace Chen)
Hi Leon- like Grace, I tried to execute a query via db2 connect selecting data from 2 tables across subsystems. I tried first using an alias and then a 3 part name. Both times I rec'd -512.
This the db2 connect level we're at- sql07024 with level ident- 03050105 tokens db2 v7.1.0.60.
Our db2 connect person states this is the same as v7.2.

Are we missing some maintenance? How do we get this to work?

Thanks Shery

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Monday, December 09, 2002 6:43 AM
To: [login to unmask email]
Subject: Re: v7 joins accorss multi subsystems

DB2 Connect V7.2 and later allows you to join tables from multiple
subsystems. In version 8 we added capability to do a distributed UPDATE,
DELETE and INSERT. So, yes, you can do a SELECT ... FROM t1, t2 and have
t1 and t2 reside on separate subsystems. This capability is not limited to
simply multiple tables on a SELECT, you can have a SELECT with a subselect
from another subsystem etc.

Leon Katsnelson
Manager, DB2 Product Planning
Administration Assistant: Robin Stockfish (905) 413-3632


|---------+---------------------------->
| | "Philip, Sibimon"|
| | <[login to unmask email]|
| | .COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | LASSOC.COM> |
| | |
| | |
| | 12/06/2002 10:24 |
| | AM |
| | Please respond to|
| | DB2 Data Base |
| | Discussion List |
| | |
|---------+---------------------------->
>-------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| Subject: Re: v7 joins accorss multi subsystems |
| |
| |
>-------------------------------------------------------------------------------------------------------------------------------------|



"Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability."

You can do this in Microsoft SQLserver with our any problem. You can create
a link server and join any table in any server. We use it a lot.

Thanks..sibi


-----Original Message-----
From: Sherri Sterling DIGEST NOMIME
[mailto:[login to unmask email]
Sent: Friday, December 06, 2002 08:59 AM
To: [login to unmask email]
Subject: v7 joins accorss multi subsystems


We are at the same delima. We even have data sharing groups and still
cannot join two different tables from two subsystems within the same sql.
We have to select one and use a global temp table and select from the
other one and manipulate the global temp tables. Here is a good white
paper from Craig Mullens on this subject,
www.dbazine.com/mullins_drda.html

A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
statements to read and/or modify multiple RDBMSs within a single unit of
work. However, only one RDBMS can be specified per SQL statement.

Distributed Request enables this above feature, however there are no RDBMS
products that currently provide DRDA distributed request capability.

Sherri Sterling



the





the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can






D A

Re: v7 joins accorss multi subsystems
(in response to HEPP SHERY C)
Hi,
You don't even need Datajoiner for that - DB2 UDB Enterprise Edition v7 (on
Windows or Unix) allows you to create a federated database, so you can link
the tables residing on DB2 for OS/390. I tried that.
On top of that, you _should_ be able to connect to that federated database
from your OS/390 and join two tables in one SQL. I never tried this, so you
have to verify that.
Best Regards,
Daniel

On Fri, 6 Dec 2002 10:29:45 -0500, The Fillmore Group, Inc.
<[login to unmask email]> wrote:

>
>Sherri,
>One solution is to install DataJoiner or use the Relational Connect
feature of DB2 UDB to access multiple DB2 databases in a single SQL
statement. DJ
>and RC are typically used to access heterogeneous databases, in your case
it's all DB2 and those products essentially don't care. I know you would
>probably prefer to keep everything on the host; although DJ is not yet
supported on Linux, DB2 UDB (with Relational Connect) runs on Linux for
zSeries.
>You can set up a Linux LPAR on your zSeries hardware and have that serve
as the front-end for your queries to multiple databases. This roughly
>approximates the functionality of DRDA Distributed Request.
>
>Let me know if you need more details.
>
>HTH,
>Frank
>
>
>On Fri, 6 Dec 2002 09:59:20 -0500, Sherri Sterling DIGEST NOMIME wrote:
>
>>We are at the same delima. We even have data sharing groups and still
>>cannot join two different tables from two subsystems within the same sql.
>>We have to select one and use a global temp table and select from the
>>other one and manipulate the global temp tables. Here is a good white
>>paper from Craig Mullens on this subject,
>>www.dbazine.com/mullins_drda.html
>>
>>A quote from that article is "Simply stated, DRDA DUW enable multiple SQL
>>statements to read and/or modify multiple RDBMSs within a single unit of
>>work. However, only one RDBMS can be specified per SQL statement.
>>
>>Distributed Request enables this above feature, however there are no RDBMS
>>products that currently provide DRDA distributed request capability.
>>
>>Sherri Sterling
>>
>>
>>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can be
>
>
>
>+-------------------------------------+------------------------------------
--+
>| Frank C. Fillmore, Jr. | Voice/Fax:
410.465.6335 |
>| The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-
RDBMs |
>| 3213-A Corporate Court | E-mail: [login to unmask email]
rdbms.com |
>| Ellicott City, Maryland 21042-2247 | URL:
http://www.thefillmoregroup.com |
>| USA
| |
>+-------------------------------------+------------------------------------
--+
>| DB2 Family, Oracle, Client/Server, Distributed
Database |
>| "Relational Database
Solutions"(sm) |
>+--------------------------------------------------------------------------
--+
>
>



Sherri Sterling

v7 joins accorss multi subsystems
(in response to D A)
I don't think so Tim! I a non-data sharing environment with only db2
family of products, you get a -512. I have tried this several different
ways. You can select and you can update but you cannot join in the same
sql statement. I have not tested this in a stored procedure. Has anyone
else on this list?

Sherri Sterling



D A

Re: v7 joins accorss multi subsystems
(in response to Sherri Sterling)
Hi,
I successfully joined two tables (residing on two different subsystems)
from OS/390 application. Now I can confirm that you can connect from OS/390
to a federated database (on DB2 UDB EE for Win/Unix) and join two tables
that actually reside on two different DB2 subsystems (on OS/390).
Daniel

On Wed, 11 Dec 2002 04:55:27 -0600, Daniel <[login to unmask email]> wrote:

>Hi,
>You don't even need Datajoiner for that - DB2 UDB Enterprise Edition v7 (on
>Windows or Unix) allows you to create a federated database, so you can link
>the tables residing on DB2 for OS/390. I tried that.
>On top of that, you _should_ be able to connect to that federated database
>from your OS/390 and join two tables in one SQL. I never tried this, so you
>have to verify that.
>Best Regards,
>Daniel