Contents Index Cursor sensitivity example: an updated row Sensitive cursors

ASA Programming Guide
  Using SQL in Applications
    Adaptive Server Anywhere cursors

Insensitive cursors


These cursors have insensitive membership, order, and values. No changes made after cursor open time are visible.

Insensitive cursors are used only for read-only cursor types.

Standards 

Insensitive cursors correspond to the ISO/ANSI standard definition of insensitive cursors, and to ODBC static cursors.

Programming interfaces 
Interface Cursor type Comment
ODBC, OLE DB, and ADO Static If an updatable static cursor is requested, a value-sensitive cursor is used instead.
Embedded SQL INSENSITIVE or NO SCROLL
JDBC Unsupported
Open Client Unsupported
Description 

Insensitive cursors always return rows that match the query's selection criteria, in the order specified by any ORDER BY clause.

The result set of an insensitive cursor is fully materialized as a work table when the cursor is opened. This has the following consequences:


Contents Index Cursor sensitivity example: an updated row Sensitive cursors