Row fetching 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.

 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 SADataReader.NextResult method [SQL Anywhere .NET].

  • 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 Result sets in ODBC applications.

  • 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 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 Cursors and the Open Client interface.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1