ASA Programming Guide
Using SQL in Applications
Adaptive Server Anywhere cursors
Adaptive Server Anywhere cursors are classified by their sensitivity with respect to changes of the underlying data. In particular, cursor sensitivity is defined in terms of which changes are visible.
Insensitive cursors The result set is fixed when the cursor is opened. No changes to the underlying data are visible.
For more information, see Insensitive cursors.
Sensitive cursors The result set can change after the cursor is opened. All changes to the underlying data are visible.
For more information, see Sensitive cursors.
Asensitive cursors Changes may be reflected in the membership, order, or values of the result set seen through the cursor, or may not be reflected at all.
For more information, see Asensitive cursors.
Value-sensitive cursors Changes to the order or values of the underlying data. The membership of the result set is fixed when the cursor is opened.
For more information, see Value-sensitive cursors.
The differing requirements on cursors place different constraints on execution, and so performance. For more information, see Cursor sensitivity and performance.