SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Static SQL Cursors
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
6-16
Cursor Sensitivity
If your program is accessing a copy of a row instead of the actual row, the cursor
points to a copy of the data, and the data is concurrently available to other programs.
For more information, see the SQL/MX Reference Manual.
Cursor Sensitivity
The ANSI standard defines three types of cursor sensitivity: INSENSITIVE,
SENSITIVE, and ASENSITIVE. NonStop SQL/MX and NonStop SQL/MP provide only
ASENSITIVE behavior, which means that the cursor might or might not see the effects
of other DML operations that are performed within the same transaction. For example,
if you have concurrent DML operations, such an INSERT, a standalone UPDATE, or
standalone DELETE, the result of those operations might not be visible to the cursor.
However, any changes you perform by using UPDATE WHERE CURRENT OF or
DELETE WHERE CURRENT OF are visible to the cursor.