Re: Database and push channels

At 07:20 PM 7/14/97 EDT, you wrote: > >Hello, > > 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? > I believe you may be able to use stored procedures for this. Not sure of the syntax, but I remember from my relational database theory course that any respectable DBMS should provide ways to implement ON DELETE ... and ON UPDATE ... etc. In Informix, I think you may use the SYSTEM command to execute UNIX (system) commands, so you may be able to do something like: on update of <table> system "sendmail <yourname> 'Table <tablename> has been updated.>" I'm not sure how you may get info on the exact row that was deleted/updated, or how to interface with your fax/phone/pager, but I hope I helped to start you off on the right track. Do you have manuals on stored procedures? Best regards, Nigel +--------------------------------------------------------------------+ |Name : Edmund Nigel Gall Atlantic Avenue | |Title : Information Systems Specialist Pt. Lisas Industrial Estate| |Company: Process Plant Services Ltd. Pt. Lisas, Couva | | Trinidad & Tobago, W.I. | | Business Personal | | mailto:nigelg@ppsl.com mailto:nigelg@ppsl.com | | Phone : (868) 636 3153/2878/3195 Phone : (868) 662 6611 | | Fax : (868) 679 3770 Fax : (868) 662 6611 | +------------------------ http://www.ppsl.com -----------------------+