Page 1 of 1

Dynamic Sql

PostPosted: Thu Jun 09, 2011 9:48 am
by kanakara.vaddi
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.

Re: Dynamic Sql

PostPosted: Fri Jun 10, 2011 1:09 am
by dick scherrer
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.