wht happens if we close cursor with cursor with hold option?
Answer Posted / rohit mishra
Once u issued a close cursor statement , it will get closed.
You can not access it after that until u open it again.
In that case your procedure will exit with an error message
like
"SQL0501N The cursor specified in a FETCH or CLOSE
statement is not open. SQLSTATE=24501"
With hold option doesn't make any difference in this case.
But if you are doing a commint operation in between your
transactions then a cursor declared with 'with hold' option
will not get closed.
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Are view updateable?
Define sqlca.
Define db2.
Explain about rct in db2?
What are union and union all?
What is explain in db2?
How do I connect my db2 database to ibm?
What is the information associated with sysibm.syslinks table?
What is the latest version of ibm db2?
What are bind parameters in db2?
How to execute stored procedure in db2 command editor?
i want to maintain uniqueness on pdf without make lf??????????
Give the name of some fields form sqlca.
What is db2 purescale?
Is schema the same as database?