hasMoreRows()

Determines whether the query result has more rows to process .

Syntax

boolean hasMoreRows()
 

Parameters

None.

Return values

Returns true if more rows exist.

Exceptions

CwDBSQLException - If a database error occurs.

Notes

The hasMoreRows() method determines whether the query result associated with the current connection has more rows to be processed. Use this method 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 hasMoreRows() returns false, you lose the data from the initial query.

See also

"Executing static queries that return data (SELECT)"

executePreparedSQL(), executeSQL(), nextRow()

Copyright IBM Corp. 2003, 2004