Re: [EXTERNAL] Is it possible to rename a trigger?

I think Alan Campin has a trigger manager - THAT is the program named as
the trigger, it calls the actual programs, which are renameable, since
they are not directly tied to any table.

Regards
Vern

On 10/7/2019 5:01 PM, Mark Waterbury wrote:

AFAIK, as long as the trigger program is attached to a PF and the file

is "open" in any jobs, the database manager (Db2i) will have locked the
program object, preventing it from being renamed or deleted "out from
under" the database while the file is active.

Once the file is closed and no jobs have any locks on the file, there

should also be no locks on the trigger *PGM(s) and you could rename it, or
more likely, replace it with a new version.

But if you really wanted to "rename" it, and have it still "work" as a

"trigger" then as James suggests, you would need to issue RMVPFTRG, then
rename it, then ADDPFTRG to re-attach it to the database physical file with
the new object name.

On Monday, October 7, 2019, 5:55:22 PM EDT, <

jamesl@xxxxxxxxxxxxxxxxx> wrote:

>A trigger is just a program (?) therefore you could use

RNMOBJ

A trigger is also a named attribute of a file. Dunno if there's a way to

rename that, short of doing a RMVPFTRG, followed by an ADDPFTRG. Also dunno
what effect renaming the program would have.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

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