Re: Update files across Partitions with Remote SQL

Hi Vern

Thanks for your reply, much appreciated.

From the fact I have not had much feedback I can only deduce what

I said is true. Your point about an expensive NON-AS400 solution
only reinforces my well known paranoia about OS400 (nuff said).

My application is quite simple. I have an application that runs in
separate partitions. The application uses common data (say product
information). Only one person maintains product information in one
partition. This information needs to be then maintained in all partitions.
Presently it is done by maintenance being done 3 times. We create
transactions then post the transactions in each partition after FTPing
the transactions.
I want to simply update the files as needed in each partition.
I believe I can do this by passing the record to be updated as a parameter
then doing the appropriate Remote SQL.

I was just curious to see if there is a another way for Remote SQL
to see data in more that one partition.

But I am dissapointed by the cumbersome process to even compile
a REMOTE SQL program. This is my last word on this topic.

Many thanks and regards
Frank Kolmann

date: Mon, 15 Dec 2008 17:28:51 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>
Hi Frank
Figured you knew that stuff, just threw it out just in case.
One expensive solution is IBM federation support - I think it's part of
their Information Integrator or Data Integrator or whatever - makes
several remote databases all look like one DB2 instance on a PC.

I do forget - is there any point to maybe bringing a chunk of data to
the program, store it somewhere, change connections, get some more,
store again, process? Again, ugly!

Later
Vern