Database cursors are used in Silk Performer for the following tasks:
Establishing a connection to a database
Relating SQL commands to a database connection
Querying the results of database operation
Fetching result sets (scrollable cursors)
Database cursors as used in Silk Performer are equivalent to ODBC statement handles; we use the terms synonymously.
You need not declare a database cursor explicitly. Cursors are declared implicitly by using the cursor. The scope of a cursor is global. Transactions share cursors with identical names.
You cannot use the name of a cursor defined as a result-set cursor in any transaction other than a scroll forward cursor.
Silk Performer establishes as many ODBC statement handles to the database(s) as database cursors are applied by the transactions of the user.