We have a similar process - we have the Trigger write a record to an "audit" file. Then there's a separate Phantom running that's polling the audit file and doing what-ever.
Mark -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 12: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" <jscha...@gmail.com> 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 >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ------------------------------------------------------------------------ _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
