Position cursor and read row

If you want to read a row in the cursor table, you must position the cursor on this row with FETCH. The column values of the current row are fetched into host variables or into a descriptor area (see section “Descriptor area”).

In order to read the next row, the cursor must be repositioned. A cursor declared with SCROLL can be positioned freely. A cursor defined without SCROLL or with NO SCROLL can only be positioned on the next row.