Dynamic cursor descriptions

A cursor can also be assigned a dynamic cursor description in the DECLARE CURSOR statement. The cursor is then referred to as a dynamic cursor. A non-dynamic cursor is also referred to as a static cursor. A dynamic cursor description is prepared with the PREPARE statement.

The figure below provides you with an overview of the SQL statements for dynamic cursor descriptions:

The other SQL statements relevant to cursors are described in the sections “Read-only cursors” and “Updatable cursors”.