Re: RPG IV Performance

[Lisa.Abney@xxxxxxxxxxxxxxxxxxxx]

"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
+---