Declaring a rowset cursor

Before you can use a rowset-positioned cursor to retrieve rows, you must declare a cursor that is enabled to fetch rowsets. When you declare a cursor, you identify a set of rows that are to be accessed with the cursor.

About this task

For restrictions that apply to rowset-positioned cursors and row-positioned cursors, see Declaring a row cursor.

Procedure

To declare a rowset cursor:

Use the WITH ROWSET POSITIONING clause in the DECLARE CURSOR statement.

The following example shows how to declare a rowset cursor:

EXEC SQL
  DECLARE C1 CURSOR WITH ROWSET POSITIONING FOR
    SELECT EMPNO, LASTNAME, SALARY
      FROM DSN8D10.EMP
END-EXEC.