Dynamic Sql

IBM's flagship relational database management system

Dynamic Sql

Postby kanakara.vaddi » 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.
Posts: 3
Joined: Mon Dec 20, 2010 6:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Dynamic Sql

Postby dick scherrer » Fri Jun 10, 2011 1:09 am


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.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post