It indicates that the iterator fetches rows in a result table in the forward
direction, from first to last.
FETCH_REVERSE
Format:
public static final int FETCH_REVERSE
A constant that can be used by the following methods:
v Set by sqlj.runtime.Scrollable.setFetchDirection and
sqlj.runtime.ExecutionContext.setFetchDirection
v Returned by sqlj.runtime.ExecutionContext.getFetchDirection
It indicates that the iterator fetches rows in a result table in the backward
direction, from last to first.
This value is not returned by IBM Informix Dynamic Server.
FETCH_UNKNOWN
Format:
public static final int FETCH_UNKNOWN
A constant that can be used by the following methods:
v Set by sqlj.runtime.Scrollable.setFetchDirection and
sqlj.runtime.ExecutionContext.setFetchDirection
v Returned by sqlj.runtime.ExecutionContext.getFetchDirection
It indicates that the iterator fetches rows in a result table in an unknown order.
This value is not returned by IBM Informix Dynamic Server.
INSENSITIVE
Format:
public static final int INSENSITIVE
A constant that can be returned by the getSensitivity method. It indicates that
the iterator is defined as INSENSITIVE.
SENSITIVE
Format:
public static final int SENSITIVE
A constant that can be returned by the getSensitivity method. It indicates that
the iterator is defined as SENSITIVE.
This value is not returned by IBM Informix Dynamic Server.
Methods
clearWarnings
Format:
public abstract void clearWarnings() throws SQLException
After clearWarnings is called, getWarnings returns null until a new warning is
reported for the iterator.
close
Format:
public abstract void close() throws SQLException
Closes the iterator and releases underlying database resources.
300 Application Programming Guide and Reference for Java
â„¢