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.
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 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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|