This release supports both user-defined and system-defined extended stored procedures (ESPs).
ESPs provide a method for calling procedural language functions from within Adaptive Server. The procedural language in which the functions are written must be capable of calling C language functions and manipulating C data types.
ESPs allow Adaptive Server to perform a task outside Adaptive Server in response to an event occurring within Adaptive Server. For example, a procedural task outside the relational database management system (RDBMS), such as selling a security, could be invoked by a trigger on a database table that fires when the value of the security reaches a certain value. Or an email notification or a network-wide broadcast could be sent in response to an event occurring within the RDBMS.
The interface to ESPs is similar to the interface to system procedures and user-defined stored procedures. The difference is that an ESP executes procedural language code, rather than Transact-SQL statements.
