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 4.0 specification 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.
![]() |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |