Cursor Characteristics

You can declare a cursor as a sequential cursor (the default), a scroll cursor (by using the SCROLL keyword), or a hold cursor (by using the WITH HOLD keywords). The SCROLL and WITH HOLD keywords are not mutually exclusive. Sections that follow explain these structural characteristics.

A Select or Function cursor can be either a sequential or a scroll cursor. An Insert cursor can only be a sequential cursor. In ESQL/C routines, Select, Function, and Insert cursors can optionally be hold cursors. (In SPL routines, all cursors are sequential cursors, but only Select cursors can be hold cursors.)