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
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).
Continue to fetch the next row until you get a
Row Not Found error.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|