Cursor Sensitivity to Change

Embedded SQL for C and SQL Server

Embedded SQL for C and SQL Server

Cursor Sensitivity to Change

In ESQL/C, standard cursors fall into one of two categories, depending on their sensitivity to change:

Keyset-Driven

Values can change, but order and membership in the result set remain fixed at cursor-open time.

Dynamic

Values, order, and membership in the result set can change.