RE: Where to place trigger programs?

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.

That's enough for me.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> Peter.Colpaert@xxxxxxxxx
> Sent: Friday, February 17, 2006 5:54 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Where to place trigger programs?
> 
> Hi group,
> 
> We will start using trigger programs soon (in the testing 
> phase for the 
> moment) to facilitate and automate logging of database changes.
> 
> I have seen threads on triggers where it is said that it's 
> best to put 
> them in the same library as the data files, and others where this is 
> discouraged.
> 
> In order to allow us to make a decision, I'd like to hear 
> advantages and 
> disadvantages from either point of view.
> 
> Thanks in advance, and have a nice weekend (I'm off in 5 minutes ;-)
> 
> Peter Colpaert
> Application Developer
> PLI - IT - Kontich, Belgium
> -----
> Yoda of Borg are we.  Futile is resistance, assimilated will you be.
> -----
> -- 
> 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.
> 
>