Re: Activation group for an AFTER external database trigger...

Rob,

Here are my thoughts:

1) Never use *NEW for a trigger or any other program thats intended to
run repeatedly.

2) You should almost always use *CALLER on a trigger. Imagine a
scenario where your trigger updates another table (file) or similar. If
it is not *CALLER, then those updates can run in a separate commit
scope, which means that you can't commit/rollback changes consistently.

3) The exception: If you know you will never use commitment control,
but you do have processes that use RCLRSC, and you use a service program
from your trigger, using *CALLER will be harmful because the service
program will go haywire after the RCLRSC if its run within the default
activation group.

4) My thoughts in (3), above, are an oddball scenario. A better fix
would be to eliminate the RCLRSC commands (it is 2020, after all, not
1989) as they will doubtless cause bigger problems. Its far more likely
(at least, HOPEFULLY, its more likely) that your shop will move more
towards modular programming and proper transaction handling with
commitment control vs. moving backwards towards 1980's style RPG
programming. So remove the RCLRSC, and use *CALLER.

-SK

On 11/4/2020 10:22 AM, Robert Rogerson wrote:

Hi All, I've been trying find how to define the activation group on an
external (RPG) database trigger.
Should I be using ctl-opt actgrp(*new) orctl-opt actgrp(*caller)?

If anyone knows of a link to a reference that would be great too.

Thanks,

Rob

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com