Interested to Buy Any Domain ? << Click Here >> for more details...
wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 12265 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 it compulsory commitment control in journal?
Which components manage deadlocks in db2?
What is the use of with ur in db2?
Explain how can you do the explain of a dynamic sql statement?
Can we update view in db2?
Explain the function done by data manager?
What is the maximum size of varchar data type in db2?
What is db2 and what is the use of db2 optimizer?
What is null indicator in db2?
How is the value function used?
Why db2 is called db2?
Define db2.
What is load replace in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is cobol db2?
