Has More Rows

Determines whether the current query result has more rows to process.

Inputs

Database connection
A CwDBConnection object that represents the database connection.

Output

Returns true if there are more rows to process in the query result; otherwise, returns false.

Exceptions

The Has More Rows function block can throw the CwDBSQLException exception if a database error occurs.

Notes

The Has More Rows function block determines whether the query result associated with the current connection has more rows to be processed. Use this function block to retrieve results from a query that returns data. Such queries include a SELECT statement and a stored procedure. Only one query can be associated with the connection at a time. Therefore, if you execute another query before Has More Rows returns false, you lose the data from the initial query.

Related information

This function block is based on the CwDBConnection.hasMoreRows() method. For more information, see hasMoreRows().

Copyright IBM Corp. 2004