How real-time does it need to be? Could you write them to a queue file and have a small batch process pick them up and email them? Rob Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.
>>> Jeff Schasny <jscha...@gmail.com> 7/30/2010 2:47 PM >>> 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