Re: Database and push channels

>From: Donny Tjandra <donnyt@lri.ucsf.edu> >Date: Mon, 14 Jul 1997 12:53:26 -0700 >X-Informix-List-Id: <news.40403> > > I am seeking a way to subscribe to a row in a table in a database. > When the row is updated or deleted, I get automatic notification by > email, fax, phone, etc. Can any database product do this, and if not > how would one go about implementing something like this? With Informix, you could use a trigger ON DELETE or ON UPDATE to kick off a stored procedure which would, presumably, scan through a separate table of subscriptions for notification. The SP would presumably use the SYSTEM statement (but not on an NT OnLine system) to dispatch the information by email, fax, phone or whatever. This could easily be horribly inefficient -- you wouldn't want to do it on every table in your main OLTP database. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: I decline to respond to messages with anti-spam in the return path.