On Wed, Nov 13, 2019 at 7:15 AM Vinay Gavankar <vinaygav@xxxxxxxxx> wrote:

I have a few questions. How is the program invoked on file update? Does it
always get a fresh copy? If not, is it possible to code something which
will execute only once?

Depend on rather or not the program is still active in a given job...
If DFTACTGRP(*YES), then did you return with *LR = *ON?

Otherwise, will depend on rather or not the activation group is still

Best practice for triggers to to leave them active...

What I am trying to do is this: The program is reading 4 data areas using
'IN' statement. I have found that the IN statement is about 7-8 times more
'expensive' than CHAIN. I am trying to figure out if there is a way to
increase the efficiency of the Trigger program. All the 4 data areas are
really static, but CAN be changed, hence the 'IN' statement for every

That seems hard to believe...I'd suggest making sure you aren't trying to
lock the data area unless you intend to update it.

But in any case, simply use a global variable as a flag to indicate you've
already read in the data area...possibly with a timestamp so you could read
it every so often in case it's changed.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.