In article <92315.131244U31742@uicvm.uic.edu>, <U31742@uicvm.uic.edu> writes:
|> Hi,
|> We have sybase version 4 installed on sparc stations. Could someone tell us
|> how to call a C program, when a trigger is fired.
|>
You cannot make a system level call from a trigger or stored procedure, for that matter, without going through the open server.
Your question exposes a system behavior that would be _very_ nice to have. It has been discussed at several meetings of the Sybase User group enhancement committee so that users could make asynchronous calls to outside applications (like E-mail, electronic pagers, and the like). I believe that Sybase's posture is that these types of "event" based routines should be entirely handled by their open server product. Although the open server provides some very robust features and capablities, this seems like ov
er kill to me when all I want to do is send E-mail to a data administrator because some user tried to post an improper update.
