Using Extended Stored Procedures

Extended stored procedures (ESPs) provide a mechanism for calling external procedural language functions from within Adaptive Server. Users invoke ESPs using the same syntax as they use for stored procedures. The difference is that an ESP executes procedural language code rather than Transact-SQL statements.

Overview

XP Server

Dynamic Link Library Support

Open Server API

Example of creating and using ESPs

ESPs and Permissions

ESPs and Performance

Creating functions for ESPs

Files for ESP Development

Open Server data structures

Open Server return codes

Outline of a simple ESP function

ESP function example

Building the DLL

Registering ESPs

Using create procedure

Using sp_addextendedproc

Removing ESPs

Renaming ESPs

Executing ESPs

System ESPs

Getting information about ESPs

ESP exceptions and messages

Starting XP Server manually

Getting information about stored procedures


	Expand Search