Re: SQL Across Multiple AS400's

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

In addition there is, also, a Redbook (Modernizing iSeries Application 
Data Access - A Roadmap Cornerstone) that I used to build what it sounds 
like you're trying to do.  In my case I was trying to push transactions 
from one i5 to another i5 on the same network, not actually retrieve 
data for a report or such.  Strangely enough, for my first inter-system 
SQL program, it worked great; the interactive users didn't even notice a 
hiccup(slow down in response time for you non-techies).



        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Vernon Hamberg wrote:

> Find the Distributed Database Programming manual in the Database 
> section of InfoCenter - Appendix A has a simple example of connecting 
> to 2 different systems - the local RDB and a remote one. The same 
> principles apply. The functions are those related to connections. If 
> you use distributed unit of work kind of connections, you can be 
> connected to several systems - but each statement has to be processed 
> by a single system. This information is all in the above-mentioned manual.
>
> If you like the SPDMNY command, you could go with IBM's WebSphere 
> Information Integrator. Articles include
>
> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0506lin/
> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0507lin/
>
> This product runs on a PC and looks like a single DRDA database. It 
> can combine data from multiple sources - including but not limited to 
> iSeries. I am assuming that if you are connecting to iSeries only, 
> you do not need the modules for things like SQL Server - connecting 
> to iSeries should be in the product using DRDA, not ODBC.
>
> HTH
> Vern
>
> At 12:35 AM 12/15/2006, you wrote:
>
>
>  
>
> > Does anyone have an example of how to get information from files from
> > multiple AS400's with SQL ?
> > Thanks
> > Tom
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (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.
> >    
>
>