Fetch Data Rows Using Cursors

A fetch completes the cursor result set and returns one or more rows to the client. Depending on the type of query defined in the cursor, SAP ASE creates the cursor result set either by scanning the tables directly or by scanning a worktable generated by the query type and cursor type.

The fetch command positions a nonscrollable cursor before the first row of the cursor result set. If the table has a valid index, SAP ASE positions the cursor at the first index key.

• fetch Syntax
  first, next, prior, last, absolute, and relative specify the fetch direction of the scrollable cursor. If no keyword is specified, the default value is next.
• into Clause Usage
  The into clause specifies that SAP ASE returns column data into the specified variables.
• Check Cursor Status
  SAP ASE returns a status value after each fetch. You can access the value through the global variables @@sqlstatus, @@fetch_status, or @@cursor_rows. @@fetch_status and @@cursor_rows are supported only in SAP ASE version 15.0 and later.
• Get Multiple Rows With Each Fetch
  You can use the set cursor rows command to change the number of rows that are returned by fetch. However, this option does not affect a fetch containing an into clause.
• Check the Number of Rows Fetched
  Use the @@rowcount global variable to monitor the number of rows of the cursor result set returned to the client up to the last fetch. This variable displays the total number of rows seen by the cursor at any one time.