db2v8.2 fp7 solaris
when i am running a query using db2batch command i am getting the following error.
SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code
"". SQLSTATE=57033
SQL0501N The cursor specified in a FETCH or CLOSE statement is not open.
SQLSTATE=24501
but when i run the same query by puting it in a file(i.e db2 -tvf i/p.sql > o/p.out) it runs fine.
wat could be the possible reason for this difference?\
any help would be appreciated
thanks..