Page 1 of 1

with Hold cursor in a stored procedure

Posted: Mon Nov 26, 2007 4:40 pm
by venkatreddy.com
can we have with hold cursor in stored procedure? I mean, is it logical to have both with return for and with hold in a single decalration of a cursor in stored procedure?

thanks,
Venkat

Posted: Mon Nov 26, 2007 11:23 pm
by DavidatK
Check example 4 given in the

DB2 Reference

It specifically addresses your question

Dave