Thanks Simon,  I appreciate your effort.  That's pretty much
everything I need to know. ;)


On 6/19/05, Simon Coulter <shc@xxxxxxxxxxxxxxxxx> wrote:
> On 19/06/2005, at 2:23 AM, rick baird wrote:
> > 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?
> The trigger name and event information is stored as an attribute of the
> file.
> If the file and trigger program are in the same library and you RSTLIB
> they will be restored together.
> If you restore a file with triggers to a library other than the
> original library the triggers will be marked as inoperative unless both
> the file and the trigger are restored to the new library. This has to
> be done as part of the same restore operation.
> If they are in separate libraries you should ensure the trigger program
> is restored first although the system doesn't care until the trigger is
> fired so you can do it in a different order.
> Of course, the above presumes you are restoring on a system where these
> objects no longer exist or are damaged beyond use. If you are just
> trying to recover the previous state of the file and the trigger
> program is still OK then you do not need to restore the trigger
> program.
> Read the Backup and Recovery manual for more information regarding
> restoring files with triggers.
> Regards,
> Simon Coulter.
> --------------------------------------------------------------------
>     FlyByNight Software         AS/400 Technical Specialists
>     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:
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact