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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|