In summary, to get triggers working as you want in UV you need to: a) Have a stub subroutine which is globally catalogued b) This stub subroutine is the one which you attach to the trigger c) This stub subroutine calls the main subroutine which does all the work
The benefit of this is the stub subroutine will rarely change and so you will not Have to go through the whole drop/create trigger scenario. UV seems to keep Track if the called subroutine changes and will cause a runtime error if it has. You are then free to change your main subroutine as often as you like. You should Probably only catalog it though when the system is quiescent. d) If you want to execute a command from TCL which is on the banned list. Unban it e) On attribute 4 of the VOC entry for the verb e.g. SH, add an H to the list of letters. f) This will allow you to perform the command with a transaction. A trigger has an implicit transaction. This however does not get around the issue of trying to debug a program which accesses A file with a trigger on. If you execute a write or delete on this file while debugging then You will get an error....but this is a separate issue and a pet peeve of mine which is hopefully Getting sorted..... We have been using this for years with no adverse effects, but you do need to be aware that you Will not be able to rollback what you are doing...In the case of emailing though this is probably Not something that you care about. Regards, > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Barry Rutherford > Sent: Saturday, 31 July 2010 8:01 a.m. > To: U2 Users List > Subject: Re: [U2] Universe Triggers > > Have the subroutine that's called from your trigger routine write a record > into a file with the details for emailing. > > Then create a program that runs in cron that reads that file and sends your > emails > > Barry Rutherford > Programmer / Analyst > MobilexUSA > 930 Ridgebrook Rd, 3rd Floor > Sparks, MD 21152 > Local: 443-662-4101 x 6162 > Toll Free: 800-786-8015 x 6162 > Fax: 443-662-4225 > http://www.mobilexusa.com > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jeff Schasny > Sent: Friday, July 30, 2010 3:47 PM > To: U2 Users List > Subject: Re: [U2] Universe Triggers > > Thank you all. > > After much putzing with the various parts involved it is beginning to look like > my original plan of having an email message sent when someone adds a new > record to this file is not to be. Apparently executing an "SH" verb in a trigger > program is not going to happen (Verb "SH" illegal > > when a transaction is active.). Boom Splat. > > > > Henry Unger wrote: > > Lock the record before you write it. > > > > Henry Unger > > > > Sent from my iPad > > > > On Jul 30, 2010, at 2:47 PM, "Jeff Schasny" <[email protected]> > wrote: > > > > > >> So far so good. Trigger installed. Trigger blows up. My trigger > program calls the *MAIL.SEND routine (which works when called from other > programs in this account) which is apparently blowing up when attempting to > write an item to the current directory (&UFD&) at line 214. > >> > >> Anyone have a guess on what this means? > >> > >> Program "*MAIL.SEND": Line 214, FATAL: The locks necessary for > database operations at the current isolation level (0) are not held by this > process. > >> Error performing trigger for "/upg/CUBUPG/CO.TF" > >> > >> > >> > >> -- > >> > ------------------------------------------------------------------------ > >> Jeff Schasny - Denver, Co, USA > >> jschasny at gmail dot com > >> > ------------------------------------------------------------------------ > >> _______________________________________________ > >> 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 > > > > > > -- > ------------------------------------------------------------------------ > Jeff Schasny - Denver, Co, USA > jschasny at gmail dot com > ------------------------------------------------------------------------ > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > This e-mail (including any and all accompanying attachments) may contain > privileged and confidential information only meant to be accessed and used > by the intended recipient or the person(s) authorized to access and deliver > the intended recipient's e-mail. > This e-mail may contain information that is privileged or otherwise > confidential. It should not be copied or forwarded to any unauthorized > persons. If you received this e-mail in error, please delete it without copying > or forwarding, and notify the sender by reply e-mail or by calling the > MobilexUSA Privacy Office toll free at 1-866-686-1717. > Thank you for your cooperation. > _______________________________________________ > 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
