It sounds like your work file is a "permanent" file (I.e. it resides in
a library other than QTEMP). If this is true, then your trigger program
seems a trifle perilous. What happens if another user does an update to
the PF and "fires" the trigger when your RPG is rebuilding the work file
from an earlier trigger "fire"?
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Sent: Monday, August 04, 2014 9:12 AM
To: Midrange Systems Technical Discussion
Subject: Trigger issue with authority
I had a case happen that the trigger would not run.
the trigger is on a physical file which has 2 logicals to it. I have a
that will be updated when one field in the PF changes.
When change made and trigger is invoked i run a CL program
which clears my work file and then rebuilds it via RPGLE program.
that is all the CL does, CLear and run the RPG.
But got an error CPF3137 NO Authority to clear, initialize etc.
Do I need now to change the authority on that Temp file I created? the
*PUBLIC * CHANGE
i am also on their with *ALL.