Re: New application using remote databases from RPG program

Steve

With DRDA you can be connected to only one iSeries at a time - you can't join data from one iSeries with another in one statement.

IBM do have some federation stuff in their WebSphere Data Integrator product - one of the big $$$s things. That could connect to several databases, but I don't think that is what you want, anyhow. Individual connections to get that data, then move on to the next - either using DDM or DRDA remote database.

Good luck
Vern

sjl wrote:

Nathan -

We are gathering inventory balances and cost from the appropriate JDE files in all affiliates.

This information, once gathered into one comma or tab-delimited file in the special environment, will then be FTP'd to be processed by a BI application running on a PC server. Once the data is successfully obtained from /all/ 52 environments, the client (another department within the company) wants the aggregated data sent all at once, not 52 separate times...

- sjl


Nathan wrote:
Steve,

What would be the purpose of transferring the data to the "local" system?
Why not just read remote data and output it to the client?
Are we talking 5250 or browser?
Would the new application be updating remote data, or just inquiry?

Nathan.