Fetching rows through a cursor

The simplest way of processing the result set of a query using a cursor is to loop through all the rows of the result set until there are no more rows.

To loop through the rows of a result set

  1. Declare and open the cursor (embedded SQL), or execute a statement that returns a result set (ODBC, JDBC, Open Client) or SADataReader object (ADO.NET).

  2. Continue to fetch the next row until you get a Row Not Found error.

  3. Close the cursor.

How step 2 of this operation is carried out depends on the interface you use. For example,

  • ADO.NET   Use the SADataReader.NextResult method. See NextResult method.

  • ODBC   SQLFetch, SQLExtendedFetch, or SQLFetchScroll advances the cursor to the next row and returns the data.

    For more information about using cursors in ODBC, see Working with result sets.

  • JDBC   The next method of the ResultSet object advances the cursor and returns the data.

    For more information about using the ResultSet object in JDBC, see Returning result sets.

  • Embedded SQL   The FETCH statement carries out the same operation.

    For more information about using cursors in embedded SQL, see Using cursors in embedded SQL.

  • Open Client   The ct_fetch function advances the cursor to the next row and returns the data.

    For more information about using cursors in Open Client applications, see Using cursors.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1