RE: RPG IV Performance

Lisa,

I thought I'd share my experience/use of triggers/data queues/etc.  We implemented JDE about a year ago, in steps.  Since all JDE apps where not in place, we needed to feed JDE data to legacy systems.  Let's assume the following for a simple example.  I needed to keep the legacy system customer master in sync with the JDE customer master.  Here's how I handled it.  1)  Attached 3 triggers to the JDE customer master (1 *AFTER *INSERT, 1 *AFTER *DELETE, 1 *AFTER *UPDATE).  2) The same trigger program was used for all 3 triggers, and all it did was send the trigger buffer data to a data queue.  3) A never ending program was waiting waiting for an entry to arrive on the data queue and processed it based on the trigger event.

-----Original Message-----
From:   Lisa.Abney@universalflavors.com [SMTP:Lisa.Abney@universalflavors.com]
Sent:   Wednesday, January 24, 2001 7:54 AM
To:     RPG400-L@midrange.com
Subject:        Re: RPG IV Performance





"2.  These "consultants" do not understand true UDB/400 triggers, and have
written some sort of "NEP" solution involving read waits and data queues
instead of utilizing the native "TRG" commands.

The more I think about it, the more the latter seems to be the case.  I
suppose that the "acid test" would be to ask your consultants which AS/400
command adds a trigger to a file, and which removes it.  During add, what is
the significance of the ALWRPTCHG parameter?"

Dean ... Very good points.  They said they were planning on using the data que
so that we would have "real time" data, but, as the application in question is
the BPCS cost roll, which is only run once a month, I questioned them on that,
and they thought maybe they would reconsider the use of the job que.  I will
question them some more about "triggers" ... you may be right, that they don't
really understand how they work.  They were very clear that the program would
run "all of the time" in the background, and, even with my very limited reading
of triggers, that doesn't sound right.

Thanks for the help!




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---