Re: Database and push channels

In article <5qjsjc$kct@ari.ari.net>, Teresa Larson wrote: >Donny Tjandra (donnyt@lri.ucsf.edu) wrote: >: 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? > >In the current release of Sybase this type of thing is implemented using >Open Server. I understand that the next major release of Sybase will >provide the ability to invoke an operating system command/script/program >from a stored procedure, but it's not here now. One way to accomplish that with what is available now (and without using Open Server) would be to use sp_sendmsg and writing a server to listen what is being sent. This would be far from optimal solution though. One thing to keep in mind is that sp_sendmsg uses UDP so there is no guaranteed delivery. Open Server would be the best choice before the Adaptive Server is released. -Petteri -- email: pjx@iki.fi.AND.NO.FSCKING.SPAM