IBM DB2 User Manual

getFetchDirection()
Format:
public abstract int getFetchDirection() throws SQLException
Returns the fetch direction of the iterator. Possible values are:
sqlj.runtime.ResultSetIterator.FETCH_FORWARD
Rows are processed in a forward direction, from first to last.
sqlj.runtime.ResultSetIterator.FETCH_REVERSE
Rows are processed in a backward direction, from last to first.
sqlj.runtime.ResultSetIterator.FETCH_UNKNOWN
The order of processing is not known.
isAfterLast()
Format:
public abstract boolean isAfterLast() throws SQLException
Returns true if the iterator is positioned after the last row of the result table.
Otherwise, returns false.
isBeforeFirst()
Format:
public abstract boolean isBeforeFirst() throws SQLException
Returns true if the iterator is positioned before the first row of the result table.
Otherwise, returns false.
isFirst()
Format:
public abstract boolean isFirst() throws SQLException
Returns true if the iterator is positioned on the first row of the result table.
Otherwise, returns false.
isLast()
Format:
public abstract boolean isLast() throws SQLException
Returns true if the iterator is positioned on the last row of the result table.
Otherwise, returns false.
last()
Format:
public abstract boolean last() throws SQLException
Moves the iterator to the last row of the result table.
Returns true if the iterator is on a row. Otherwise, returns false.
previous()
Format:
public abstract boolean previous() throws SQLException
Moves the iterator to the previous row of the result table.
Returns true if the iterator is on a row. Otherwise, returns false.
relative(int)
Format:
Chapter 7. JDBC and SQLJ reference information 303

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability