Re: Censoring SQL access -- ideas?

You can access remote systems on IBM i, unless I'm misunderstanding you,
you're wrong. I've done this for years accessing DB2/400 (and now I guess
it's DB2 for IBM i, Trevor can clarify that one for me ;) ). You can't
JOIN across the 2 systems but you *can* use RDB/DRDA on IBM i.

Thanks,
Tommy Holden



From: Charles Wilt <charles.wilt@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/17/2011 07:50 AM
Subject: Re: Censoring SQL access -- ideas?
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Sure, if you're running in DB2 for LUW, Oracle, MS SQL Server....

But not on IBM i...

In fact, those other DB's can join tables across platforms, not just
remote DB's on the same platform.

Charles

On Thu, Mar 17, 2011 at 8:29 AM, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
wrote:

Somebody else mentioned this to me, Tommy. I should know more about
this. I'm going to do some research. Can you JOIN files in two
different databases?

Joe

Sure it can be done with SQL. You set up an RDB entry pointing to the
other system and use CONNECT to access the data on the remote system.

Thanks,
Tommy Holden