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.