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.