Interested to Buy Any Domain ? << Click Here >> for more details...
wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 12293 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
How do I copy a table in db2?
What is load utility in db2?
What is consistency token in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is database alias db2?
What is coalesce in db2?
Why cursor is used in db2?
What is cursor in dbms?
What is the difference between drop table and delete table?
Define db2.
What is db2 purescale?
Comment whether the cursor is closed during commit or not.
What is the role of schema in the db2 database?
What is bind in db2?
Are view updateable?
