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: > That's what I did, Perry! GMTA ;) > > > > On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor <[email protected]>wrote: > >> You can globally catalog in a Pick-flavored account. Copy the >> CATALOG VOC record from the UV account to your Pick-flavored account >> VOC renaming it something like ICATALOG. We do it all the time for our >> file-based triggers. >> >> Perry >> >> -----Original Message----- >> From: [email protected] [mailto: >> [email protected]] On Behalf Of Bobby Worley >> Sent: Friday, January 25, 2013 3:03 PM >> To: U2 Users List >> Subject: Re: [U2] Triggers in Universe >> >> The problem was the locally cataloged program. I was in an account that >> is PICK flavor and wouldn't allow global cataloging. When I catalog >> the program globally from the UV account the CREATE TRIGGER now works. >> Thanks! >> >> >> >> >> >> On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob >> <[email protected] >>> wrote: >> >>> In Unidata the problem would be that the trigger has to be cataloged >>> globally, not locally. I'm not sure how to do that in Universe, though. >>> >>> -----Original Message----- >>> From: [email protected] [mailto: >>> [email protected]] On Behalf Of Bobby Worley >>> Sent: Friday, January 25, 2013 1:33 PM >>> To: U2 Users List >>> Subject: [U2] Triggers in Universe >>> >>> I'm up against a wall here - trying to use triggers for the first >>> time, >> on >>> Universe. Can't seem to get my test to work - >>> >>> Universe on AIX: >>> >>> RELLEVEL >>> 001 X >>> 002 11.1.9 >>> 003 PICK >>> 004 PICK.FORMAT >>> 005 11.1.9 >>> >>>> BASIC BDW TRIGTEST >>> Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' >>> * >>> >>> Compilation Complete. >>> >>>> CATALOG BDW TRIGTEST >>> "TRIGTEST" cataloged. >>> >>>> .L TRIGTEST >>> >>> TRIGTEST >>> 001 V >>> 002 BDW.O/TRIGTEST >>> 003 B >>> 004 BNP >>> 005 >>> 006 PICK.FORMAT >>> 007 S N P I A E H >>> 008 NO.WARN NOPAGE LPTR KEEP.COMMON TRAP HDR-SUPP >>> 009 BDW.O >>> >>> >>>> CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL >>>> FOR >>> EACH ROW CALLING 'TRIGTEST'; >>> Unable to locate trigger program "BDW.O/TRIGTEST". >>> >>> >>> -- >>> >>> ____________________**** >>> >>> *Bobby D. Worley* >>> >>> IT Applications Developer**** >>> >>> Coburn Supply Company**** >>> >>> o: 903.753.8613 | m: 214.676.9825**** >>> >>> [email protected]**** >>> >>> ** ** >>> _______________________________________________ >>> U2-Users mailing list >>> [email protected] >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> _______________________________________________ >>> U2-Users mailing list >>> [email protected] >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> >> >> -- >> >> ____________________**** >> >> *Bobby D. Worley* >> >> IT Applications Developer**** >> >> Coburn Supply Company**** >> >> o: 903.753.8613 | m: 214.676.9825**** >> >> [email protected]**** >> >> ** ** >> _______________________________________________ >> U2-Users mailing list >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> CONFIDENTIALITY NOTICE: This e-mail message, including any >> attachments, is for the sole use of the intended recipient(s) and may >> contain confidential and privileged information. Any unauthorized >> review, use, disclosure or distribution is prohibited. ZirMed, Inc. >> has strict policies regarding the content of e-mail communications, >> specifically Protected Health Information, any communications >> containing such material will be returned to the originating party >> with such advisement noted. If you are not the intended recipient, >> please contact the sender by reply e-mail and destroy all copies of >> the original message. >> _______________________________________________ >> U2-Users mailing list >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > -- > > ____________________**** > > *Bobby D. Worley* > > IT Applications Developer**** > > Coburn Supply Company**** > > o: 903.753.8613 | m: 214.676.9825**** > > [email protected]**** > > ** ** > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------------------------------------------------------- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ------------------------------------------------------------------------------- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
