Interested to Buy Any Domain ? << Click Here >> for more details...
wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 12386 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 database alias db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How can you count the number of rows from a table tab?
What is bind plan?
define clustering index.
What is isolation level in db2?
What are types of indexes?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How to access db2 tables in mainframe?
How can we retrieve the total number of records in RPG & CLLE?
What is the difference between dbm cfg and db cfg file in db2 ?
What are union and union all?
What is cursor with hold option in db2?
Explain about open switch business continuity software?
On which levels locks can be applied?
