ASA Programming Guide
Using SQL in Applications
Choosing cursor types
When you request a cursor type from your client application, Adaptive Server Anywhere provides a cursor. Adaptive Server Anywhere 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, Adaptive Server Anywhere provides a cursor with behavior to match the type.
Adaptive Server Anywhere cursor sensitivity is set in response to the client cursor type request.
ODBC and OLE DB
ADO.NET
Embedded SQL
JDBC
Open Client