Re: FW: Informix change notification

From: David Reed <david.reed@tollink.co.za> >-----Original Message----- >From: Grant Nyland > >The "Query" regarding Informix change notification : > >Table Change Event Notification in Informix > >We would like the data base to notify the application when a table has >changed. Ideally we would like to call the windows API PostMessage() from >within Informix when a trigger on the table is activated. Failing this we >would like to load a DLL and call one of its functions from the trigger (or >a stored procedure). > >Failing the above, please comment on how much of a load the writing of a >text file from a stored procedure would place on the CPU. We can monitor >for >changes to the text file. > >The worst case scenario is to launch an exe file from a triggered stored >procedure. There must be a better way... There is indeed. What you can do is to use IDS/UDO or F.2000 and the TIBCO messaging datablade. A very elegant solution, although it might be an overkill for your needs... HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com