|
On Wed, 2005-10-05 at 17:02 -0500, Glenn Holmer wrote: > On Wednesday 05 October 2005 11:50, Jose Luis Calvo wrote: > > One way to do that is using the best of the two alternatives, the > > trigger (may be in RPG) put an entry in a DTAQ, an have a Java > > program waiting in that DTAQ. > > Thanks for the replies; we're going to set up a trigger against the > database on the '400 that writes the record into a data queue. A > program on the Linux server will read from that queue and write the > record into his (Postgres) database. I'll let you know how it turns > out... Be careful with a data queue. If your updates are important, I would discourage using it. The reason is that if there are any data queue entries hanging around when the system ends (either normally or abnormally), they are cleared during the IPL. All the triggers I write save to a database file, and are pulled from there. It's a bit more resource intensive, but IMO, safer. Regards, Rich
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
