Dynamic Sql
Posted: Thu Jun 09, 2011 9:48 am
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.
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.