ASA Programming Guide
Using SQL in Applications
Choosing cursor types
Not all interfaces provide support for all types of cursors.
ODBC and OLE DB (ADO) support all types of cursors.
For more information, see Working with result sets.
Embedded SQL supports all the types of cursors.
ADO.NET provides only forward-only, read-only cursors.
For JDBC:
jConnect 4.x provides only asensitive cursors.
jConnect 5.x supports all types of cursors, but there is a severe performance penalty for scrollable cursors.
The iAnywhere JDBC driver supports all types of cursors.
Sybase Open Client supports only asensitive cursors. Also, a severe performance penalty results when using updatable, non-unique cursors.