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.
On Wed, 2005-10-05 at 11:30 -0500, Glenn Holmer wrote:
> We want to have a Postgres database on a Linux web server updated when
> the corresponding record on the AS/400 changes. We are thinking:
>
> a) DB trigger on the '400 that wakes up when the record is changed and
> calls a Java program (also on the '400), passing the needed parameters
> as arguments to main(); the Java program uses JDBC to update the
> Postgres database on the Linux server. Pro: probably easy to set up,
> Con: new process spawned for each write.
>
> b) A Java program that runs all the time and listens for changes on the
> AS/400 database using something like FileListener from the JT400
> toolbox (haven't researched this yet); he would do the same as a).
> Pro: single program, Con: don't know if it's possible.
>
> What recommendations would you guys make? We are hoping to get away
> without modifying the program that is actually making the changes on
> the '400. We are not talking about a huge number of records here;
> probably a couple hundred every few hours.
>
> --
> ____________________________________________________________
> Glenn Holmer gholmer@xxxxxxxxxxxxxx
> Software Engineer phone: 414-908-1809
> Weyco Group, Inc. fax: 414-908-1601
