FW: Informix change notification
Posted in 1999
-----Original Message----- From: Grant Nyland Sent: Monday, August 23, 1999 7:24 AM To: David Reed Subject: Informix change notification Hi David 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... Thanks Grant