Re: Information wanted on stored procedures and triggers

On 23 Nov 1994, Timothy E. Ward wrote: > One of the main reasons our organization is excited about stored > procedures is their ability to execute operating system commands on a > host from a client application. Conceivably you can trigger or "launch" > a process on the server or host based on input received at the client by > executing a procedure via SQL on the client. > > At least, this is what we are planning to use stored procedures for. Has > anyone got any feedback on this usage? ... Tim I have heard of projects that are making use of the stored procedures to execute shell scripts. I don't think there is gonna be any problem at all. But I wonder what will be the permission of the shell script, is it gonna be user Informix, or root, or ..??? While we're on this subject, what about making use of the trigger mechanism to send 'messages' to the client?? One of the application is constantly polling the database server to check a particular field, it is as frequent as once per second. That's why someone suggested that it might be more efficient if we use the trigger mechanism to notify the client application of a change instead of the constant polling that is happening now. Personally, I don't think it can be done EASILY. I don't see how the trigger mechanism can talk to the front-end application. But of course, I might be wrong, any comments on this?? If it must be done, I believe we have to go into socket programming or RPC calls. Maybe someone can suggest something more elegant. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Calvin Ng email: <calvinng@technet.sg> A new Netizen =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=