Interested to Buy Any Domain ? << Click Here >> for more details...
wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 12525 Views
- Valtech, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikkal
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 ? | 23 Yes | 2 No |
Post New Answer View All Answers
Is schema the same as database?
Why do we need reorg in db2?
What is isolation level in db2?
What does db2 plan contain?
what is the role of the cursor in db2?
Define data page.
What is ibm db2 connect?
What is the use of commit in db2?
What is a db2 schema?
What is deadlock in db2?
What is a bind in db2?
define clustering index.
What is an instance in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is a trigger in the db2 database?
