Interested to Buy Any Domain ? << Click Here >> for more details...
wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 12402 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
What is the purpose of using commit?
How do we specify index to include or not during bind process.
What is ibm db2 database?
Why cursor is used in db2?
Explain about dbrm.
What is db2 instance?
Can we update view in db2?
What is db2?
What is query_cache_limit?
What are bind parameters in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What are the rules for db2 programming?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How to execute stored procedure in db2 command editor?
