The Open ServerConnect application program uses TDINFPGM and TDGETREQ to determine what type of request the client sent. For cursor requests, the application processes cursor commands and generates result sets.
Multiple cursor commands per transaction invocation are not allowed because TRS can only pass one cursor command per TDS_CURSOR event. To process multiple commands, use the Open ServerConnect long-running transaction and accept each new command request with TDGETREQ.
Cursors are limited to SQL statements and cannot be used with other types of languages.
Cursor support is not available for Japanese or DBCS.
For example, if a client sends an OPEN CURSOR request to a DB2 application, the Open ServerConnect application is responsible for defining and executing the actual DB2 OPEN CURSOR command. Open ServerConnect is merely the transport mechanism for cursor commands.
