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
