Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.
Moderators: Kalicharan, Moderator Group
- Posts: 3
- Joined: Sat Nov 24, 2007 11:21 am
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?
- Active Member
- Posts: 65
- Joined: Tue Mar 27, 2007 8:41 am
- Location: Troy, MI USA
Check example 4 given in the
It specifically addresses your question