Re: Triggers, the library they reside in, and restoring the library

[rick baird <rick.baird@xxxxxxxxx>]

Thanks Simon,

When you say the trigger should be restored with the file, do you mean
the DB trigger event (TRGLIB parm) , or the trigger program (PGM
parm), or both?

Thanks again,

Rick

On 6/18/05, Simon Coulter <shc@xxxxxxxxxxxxxxxxx> wrote:
> 
> On 18/06/2005, at 2:02 AM, rick baird wrote:
> 
> > if a file is restored, does it fire the trigger for each record
> > restored?
> 
> No.
> 
> > - i.e. should I remove the trigger before and re-add it
> > after, as part of the process of restoring the file?
> 
> No.
> 
> > if a file with a trigger is restored, should the trigger be restored
> > with it
> 
> Yes.
> 
> > - i.e. should the trigger reside in the same library as the
> > file (TRGLIB on ADDPFTRG command)?
> 
> Yes.
> 
> > or does it matter?
> 
> Yes, unless you ensure the trigger program is restored before the file.
> 
> 
> Regards,
> Simon Coulter.
> --------------------------------------------------------------------
>     FlyByNight Software         AS/400 Technical Specialists
> 
>     http://www.flybynight.com.au/
>     Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
>     Fax:   +61 3 9419 0175                                   \ /
>                                                               X
>                   ASCII Ribbon campaign against HTML E-Mail  / \
> --------------------------------------------------------------------
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>