> Just a shot in the dark... you did open the cursor using the WITH HOLD
option, didn't you?
Thanks for the response.
Thats kind of exactly what I wanted to know - how do you open the
cursor using WITH HOLD option in JDK1.3 framework.
I am using PreparedStatement to execute the query. The method
Connection.prepareStatement(String sql, int resultSetType, int
resultSetConcurrency, int resultSetHoldability)
seems to have been added in JDK1.4 only (note the last parameter -
resultSetHoldability).
I am not sure how sure how to do it in earlier versions.
I am using DB2 8.1 fp3 Type 4 drivers (driver:
com.ibm.db2.jcc.DB2Driver). The driver return true for
supportsOpenCursorsAcrossCommit(), but I am not able to turn on the
feature!!
I am desperately in need of help :(
Thanks.