Re: Where to place trigger programs?

[Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>]

>On Fri, 17 Feb 2006 08:10:32 -0500, "Wilt, Charles" <CWilt@xxxxxxxxxxxx> wrote:

>There are issues if you restore a file that was save with a trigger
>attached and the trigger is in another library.
>
>As I recall, IBM recommends placing the trigger in the same library as
>the file.
>

I'd like some clarification on this recommendation.

I have always put our trigger program objects in our normal object library.
On the ADDPFTRG command is the TRGLIB parm which I've always left as the
default *FILE.

I have never had a problem restoring files.  I have done many DR tests since
we started using triggers and just recently did a restore onto a new 520.

Nor have I ever had a problem with CRTDUPOBJ of a file with a trigger.  In
fact we have had to do a RMVPFTRG after doing the CRTDUPOBJ because the
triggers were being fired after record were written to or updated in the
duplicate file.


Gord