RE: Triggers, Activation Groups, Performance

> -----Original Message-----
>
> As a rule, I use DFTACTGRP(*NO) and ACTGRP(QILE). Should I
> still leave LR off when I exit my program and code it to be re-enterable?
> Or can I seton LR and let the system handle re-initialization without
> any real penalty?
>
> Joe Teff
>
>
Joe:

For simplicity's sake, I would advise leaving LR off and using the
traditional technique running in ACTGRP(*CALLER) or *DFTACTGRP.

If you run the trigger program in a named activation group, any variables
which are not local to a procedure in the program are necessarily static
while the named activation group is active, so the code could be made
re-entrant with LR on if you were sure that the Activation Group remains
active.

However, since you would not want the Activation group to terminate between
successive calls of the trigger program, you would need to ensure that your
calling program runs in the same activation group as your trigger program.
This could be a little difficult since the calling program would be some
OS/400 Database Manager program. Even if you make your trigger program
ACTGRP(*CALLER), you still cannot be sure that the OS/400 program does not
terminate the activation group. (Perhaps someone from IBM could clarify
exactly what activation group the calling database manager program runs in)
If the OS/400 program runs in ACTGRP(*CALLER), then using a single
'across-the-board' named activation group would enable your trigger programs
to be re-entrant. Also, it would open up the intriguing possibility of
exporting static variables from the trigger program to and from the program
which accessed the database file to fire the trigger.

Hope this helps.

Chris Jewell

Christopher J. Jewell.vcf