Re: RPG - MsSQL Connection

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Not quite true Scott...

I know MS SQL Server's linked servers support joining between tables
on multiple systems; as does Oracle's Generic Connectivity feature.
I'd guess IBM's DB2 federation product does also.  That's one of the
points to a federated DB in the first place.

Of course the way it works is that behind the scenes, the DB pulls
rows from the remote DB into a temporary table.  If the DB is smart,
it should only pull what it needed.  But for instance, I believe MS
SQL server takes the easy route and just pulls every row from the
remote table.  Obviously not ideal when you only need  5 rows out of a
million from the remote table. :)

Charles

On Thu, Sep 9, 2010 at 2:34 PM, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx> wrote:
> Just to be clear..  it might be possible to join two DB2 tables from
> separate systems, or two SQL Server tables from separate systems...  but
> you'll never be able to join a SQL Server table to a DB2 Table.
>
> Why not?  Because they're handled by separate query engines.  The DB2
> query engine doesn't know how to use a SQL Server table or index.  The
> SQL Server query engine doesn't know how to use a DB2 table or index.
>
>
> On 9/9/2010 12:09 PM, DeLong, Eric wrote:
> > Just wondering how to handle the need to join a remote table to a local
> > table?  As an example, perhaps I need to retrieve rows from a MS-SQL
> > Server, then update a local table to match the remote.  If using
> > ARDgate, would I need to connect to the remote, then make a copy into a
> > local temp table, then connect to the local DB2 to process the update
> > statement?  I understand that DB2 Multisystem could handle concurrent
> > access (federated DB), but otherwise is not supported on IBM i.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.