Retrieving a set of rows by using a cursor

Use the following type of cursors to retrieve rows from a result segment:

• A row-positioned cursor retrieves at most a single row at a time from the result segment into host variables. At any point in time, the cursor is positioned on at most a single row. For information about how to use a row-positioned cursor, see Accessing data by using a row-positioned cursor.