Re: SEND MAIL thru TRIGGER

Posted in 1998

mike aubury — Sat, 16 May 1998 12:05:46 +0100 — source: Informix-list mailing list archive (1991-1998)

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 Use system in the SP to run mail. Its easiest to create a little wrapper around mail set set the subject etc system "mail informix < /usr/informix/inserted.txt" -- -- Mike Aubury _\\?/_ |O O| +----------oOOO-\\_/-OOOo---------+-------------------------------+ | Heisenberg may have been here | mike@aubury.demon.co.uk | | | http://www.aubury.demon.co.uk | +--------------------------------+-------------------------------+