Re: SEND MAIL thru TRIGGER

Posted in 1998

jeffso@lucent.com — Mon, 18 May 1998 08:56:52 -0400 — source: Informix-list mailing list archive (1991-1998)

Yes, it is possible, but if you put a trigger on the field, the transaction time will increase depending on which email software you use. That is because the trigger will wait for the system call to finish. If the email does not need to be in real time, I suggest you to put a cron job to scan the changes and send out the email periodically. Ramki Natesan wrote: > > Hi All, > > When a field gets updated, I need to notify bunch of people. > > How can I send an E-MAIL thru trigger mechanism in Informix. > Is is possible? > > OR Can I write a STORED PROCEDURE using I4GL? HOW? > > thanks, > /Ramki -- Jeff So Office : 973-3868839 Email : jeffso@lucent.com