wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 11396 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 use of value function?
How do I create a view in db2?
what is db2 restart?
What is db2 look?
What is the use of reorg in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is scrollable cursor in db2?
What is explain plan in db2?
What is alias in db2?
What is the syntax for FETCH in DB2 ?
What kind of database is db2?
How would you find out the total number of rows in a db2 table?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How connect db2 database to datastage?
