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