IBM Mainframe Forum

Hi ,
this is kanaka.

we are using dynamic sql in our stored procedure.

while we are trying to fetch first 20 records,after getting 20th record ,at the end of the execution, I am getting this error.
java.sql.SQLWarning: [StarSQL JDBC Driver][DB2] A CNTQRY or CLSQRY command was issued for a query that is not open.

Hello,

It sounds like there is a problem with the client code - rather than with db2. . .

Where is db2 running?

Suggest you work with your support people and compare this process with a similar one that is currently working.