a cursor normally gets closed once we provide a commit . If
u try to close the same cursor with close cursor command
later after providing the commit will there be any sql-error.
- 3 Answers
- 6635 Views
- I also Faced
- E-Mail Answers
Answer Posted / manasa
WHEN THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS
NOT OPEN,then we get -501 error.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a plan and package in db2?
What is bind in db2?
How to take backup of table in db2?
What is the role of data manager in the db2 database?
What is the difference between using bind () and rebind () methods of naming class?
How can record locking be achieved in those DB2 versions which do not support it?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is ibm db2 database?
Explain about dbrm.
What is blu acceleration in db2?
What is node in db2?
How to access db2 tables in mainframe?
Is db2 free?
What is a page in db2?
