Availability of cursors

Not all interfaces provide support for all types of cursors.

  • ADO.NET provides only forward-only, read-only cursors.

  • ADO/OLE DB and ODBC support all types of cursors.

  • Embedded SQL supports all types of cursors.

  • For JDBC:

    • The SQL Anywhere JDBC driver supports the JDBC 3.0 and JDBC 4.0 specifications and permits the declaration of insensitive, sensitive, and forward-only asensitive cursors.

    • jConnect supports the declaration of insensitive, sensitive, and forward-only asensitive cursors in the same manner as the SQL Anywhere JDBC driver. However, the underlying implementation of jConnect only supports asensitive cursor semantics.

  • Sybase Open Client supports only asensitive cursors. Also, a severe performance penalty results when using updatable, non-unique cursors.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1