Re: AW: Adopted authority and triggers

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

i've never experienced anything like that...if you restore the data 
libraries the triggers are intact (or at least they always have been when 
i've done it) with no intervention of any kind.  if you apply the triggers 
to point to the appropriate trigger program you're golden.  the trigger 
program is not really tied to the file..the trigger itself is.  the 
trigger program is simply pointed to by the trigger on the file, not 
directly linked.

Thanks,
Tommy Holden




"BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/04/2007 11:50 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
AW: Adopted authority and triggers






Hi,

> > Why is it recommended that the trigger program reside in the same 
library
as the physical file it is attached to?

Because the trigger program is directly linked with the physical file (or
SQL table). In this way it can be compared other database objects such as
logical files, SQL indexes, Views or Constraints. It is also recommended 
to
have all these objects in the same library/schema as your data.

If you put the trigger programs in an other library and have to save and
restore your data library, the trigger must be linked again with the
database, with either the CL-Command ADDPFTRG or with the SQL command 
CREATE
TRIGGER.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training 
them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Brian
Gesendet: Wednesday, April 04, 2007 16:37
An: Midrange Systems Technical Discussion
Betreff: Re: Adopted authority and triggers


Why is it recommended that the trigger program reside in the same library 
as
the physical file it is attached to?



On 4/4/07, Ed Fishel <edfishel@xxxxxxxxxx> wrote:
> Yesterday afternoon I found these recommendations in the information 
> center.
>
> <snip>


Create the program in the physical file's library.
> </snip>
Ed Fishel,
> edfishel@xxxxxxxxxx