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

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.
> 
>