Yeah, thats what I've been thinking.
Thanks all.
Barry Rutherford wrote:
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 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" <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
