You can use a cursor in a UAP to extract retrieval results.

To use a cursor, declare the cursor with DECLARE CURSOR or allocate the cursor with ALLOCATE CURSOR.

This section explains the effects of using a cursor and issues to consider when using a cursor.

Organization of this section

3.5.1 Notes on table operations when a cursor is used

3.5.2 FOR UPDATE and FOR READ ONLY clauses

3.5.3 Cursor declarations and locks

3.5.4 Holdable cursor

3.5.5 Examples of cursor use