We use named iterator to retrieve data from the result set. One of our test case is to run the same set of SQLJ statements to add, delete or get data from our database repeatedly for 7 days. When we run this case, we are able to run that same set of SQLJ statements successfully for 34 times. But it always failed on the 35th run of this test case and at the same place, i.e. in looping through the result set. The exception we got is shown below. We examine our database and see no such data in the database. Any idea or suggestion of why we are getting this error?

Thanks,
Ling



[IBM][CLI Driver][DB2/NT] SQL0433N Value "‘Ækš¬â2Y¡*+Z ûز1ôìh;¾¯ Y˜ WŽÅ&Ú 5‹ç6Ѥ¡ÅþÔò/Oز1ôìh;¾¯ Y˜" is too long. SQLSTATE=22001

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source)(Inlined Compiled Code)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(Unknown Source)(Compiled Code)
at COM.ibm.db2.jdbc.app.DB2ResultSet.next(Unknown Source)(Compiled Code)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJ dbcResultSet.java(Compiled Code))

What's the statement? Need more info. Calling any functions, built-in or otherwise?