Opening a rowset cursor

After you declare a rowset cursor, you need to tell Db2 that you are ready to process the first rowset of the result table. This action is called opening the cursor.

About this task

To open a rowset cursor, execute the OPEN statement in your program. Db2 then uses the SELECT statement within DECLARE CURSOR to identify the rows in the result table. For more information about the OPEN CURSOR process, see Opening a row cursor.