Dynamic link library support  Example of creating and using ESPs

Chapter 17: Using Extended Stored Procedures

Open Server API

Adaptive Server uses the Open Server API, which allows users to run the system ESPs provided with Adaptive Server. Users can also implement their own ESPs using the Open Server API.

Table 17-1 lists the Open Server routines required for ESP development. For complete documentation of these routines, see the Open Server Server-Library/C Reference Manual.

Table 17-1: Open Server routines for ESP support

Function

Purpose

srv_bind

Describes and binds a program variable to a parameter

srv_descfmt

Describes a parameter

srv_numparams

Returns the number of parameters in the ESP client request

srv_senddone

Sends results completion message

srv_sendinfo

Sends messages

srv_sendstatus

Sends status value

srv_xferdata

Sends and receives parameters or data

srv_yield

Suspends execution of the current thread and allows another thread to execute





Copyright © 2005. Sybase Inc. All rights reserved. Example of creating and using ESPs

View this book as PDF