Requests for SAP Sybase IQ Catalog Store Cursors

When you request a cursor type from your client application, SAP Sybase IQ provides a cursor. SAP Sybase IQ cursors are defined, not by the type as specified in the programming interface, but by the sensitivity of the result set to changes in the underlying data. Depending on the cursor type you ask for, SAP Sybase IQ provides a cursor with behavior to match the type.

SAP Sybase IQ cursor sensitivity is set in response to the client cursor type request.

• ADO.NET
  Forward-only, read-only cursors are available by using SACommand.ExecuteReader. The SADataAdapter object uses a client-side result set instead of cursors.
• ADO/OLE DB and ODBC
  The following table illustrates the cursor sensitivity that is set in response to different ODBC scrollable cursor types.
• JDBC
  The JDBC 4.0 specification supports three types of cursors: insensitive, sensitive, and forward-only asensitive. The SQL Anywhere JDBC driver is compliant with these JDBC specifications and supports these different cursor types for a JDBC ResultSet object. However, there are cases when the database server cannot construct an access plan with the required semantics for a given cursor type. In these cases, the database server either returns an error or substitutes a different cursor type.
• Embedded SQL
  To request a cursor from an embedded SQL application, you specify the cursor type on the DECLARE statement. The following table illustrates the cursor sensitivity that is set in response to different requests:
• Open Client
  As with jConnect, the underlying protocol (TDS) for Open Client only supports forward-only, read-only, asensitive cursors.