"/...but I've created systems with master triggers that read a list of
subordinate triggers from a control file and call them in order./"
This appears to be the "best practices" of managing triggers in UD.
Once explained, it seems the most logical method of managing triggers
and allowing individual dbms accounts to use local versions of trigger
subroutines.
Bill
----- Original Message -----
*From:* [email protected]
*To:* 'U2 Users List' <[email protected]>
*Date:* 1/29/2013 1:08 AM
*Subject:* Re: [U2] Triggers in Universe
Peter
Yes, they are still cached but you can derive the name - it's an overhead but
I've created systems with master triggers that read a list of subordinate
triggers from a control file and call them in order. Then these can have a
version stamp appended when catalogued.
IN practice I found the overhead of reading the list was minimal compared with
the overheads on calling the trigger in the first place, and because it's
happening all the time on a busy system that control file is constantly cached
in memory anyway.
Brian
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Peter Cheney
Sent: 28 January 2013 23:26
To: U2 Users List
Subject: Re: [U2] Triggers in Universe
Could use the trigger program to call one or more external subroutines based on
the trigger action required? I understand that the external subroutines are
not cached and can be updated without needing to stop/start the master trigger.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Brian Leach
Sent: Saturday, 26 January 2013 20:19
To: U2 Users List
Subject: Re: [U2] Triggers in Universe
Remember also that triggers, as subroutines, are cached in memory so if you
recompile a trigger the changes won't be picked up by any processes that have
not logged off or returned to TCL.
Brian
Sent from my iPad
On 25 Jan 2013, at 22:18, Bobby Worley <[email protected]> wrote:
[snipped]
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
