Something like this may work, just change the parms to suit your needs
Register Hereor login if you are already a member
We have 2 existing triggers on insert to a PF. Of course, the author is no longer available. I printed existing triggers to get the trigger names - too long so did the dspfd to get the full names. I think I have that but I see no way to be sure.
So trying to remove the 1 so I can replace it with a trigger that points to my version of the program. I get a "requirements between parameters not satisfied" error.
Is there something else I need for this ?
I'm certainly open to using a different process to change the trigger. I just want to use the revised program.
Yes, I tried to move the current program out of its library but the system wouldn't let me do that.
The message was CDP0150 - seemed generic
Got this when trying to remove the existing trigger
One complication was that the file was in use, so ending all auto-start jobs fixed that
I also tried using *ALL instead of trying to match the trigger name. That worked, tho it removed both triggers. The good news is it did let me switch the program out after that. I (re)created the 2 triggers and it worked !