I'm trying to get to randomaly selected record in the result set.
The only way I found to do so is:

currRow = (int)(Math.random() * numberOfRows);
for (int i=0; i<currRow; i++) {
m_resultset.next();
}

sometime I get exception:
java.sql.SQLException: Could not write to a temporary file.
at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:349)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav a:3043)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3353)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2254)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2174)
at com.informix.jdbc.IfxSqli.executeScrollFetch(IfxSq li.java:5166)
at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:404 3)
at com.informix.jdbc.IfxResultSet.next(IfxResultSet.j ava:525)
at DBConnection.updateRandomElement(DBConnection.java :138)
at main.main(main.java:27)


Any idea?

root dbspace? Do 'tbstat -d' while you're running the
pgm and see if any chunks get near 0 free ???