Chapter 2: Topics

Declare cursor

When the cursor command is TDS_CURSOR_DECLARE, the client is declaring a new cursor. In response, the Gateway-Library transaction calls the following functions:

Function	Action
TDCURPRO	Determine: The type of cursor command (DECLARE, in this case), and Whether or not this cursor can be used to update database tables.
TDNUMPRM	Retrieve the number of parameters associated with the cursor.
TDINFPRM	Get the format of each associated parameter (once for each parameter).
TDRCVSQL	Retrieve the SQL text associated with the cursor.
[application logic]	[Declare the cursor to the application]
TDCURPRO	Assign a cursor ID to the cursor.
TDSNDDON	Send the reply to the client.
TDGETREQ	Retrieve the next part of the cursor request.

View this book as PDF