Re: Where to put a trigger program...

Do tell - why? (Just curious to learn.)

Something that tripped us up with database triggers was multiple-member
db2 files.
It did let us attach the trigger (we did that off-hours), but when users
started using their apps using file members, we got errors (can't remember
what they were).



On Wed, Mar 17, 2021 at 3:12 PM James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

On 3/17/21 1:04 PM, Brian Parkins wrote:

Do tell - why? (Just curious to learn.)

If a trigger program needs to be changed (unless it's not an actual
trigger program, but a program called via a "trigger mediator" that's
the actual trigger), then *all* locks on *any* file to which it is
attached must be cleared before it can be recompiled.

That can be a pain in the butt at times.

--
JHHL
--
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