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.
Answer Posted / pavithra
when we try to close the cursor that is already closed, it
will return the SQL error code
-501 - cursor found in the fetch or close statement is not open.
please correct me if wrong
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to get the ddl of a table in db2?
Which isolation level provides highest data integrity?
What is view db2?
Highlight all the advantages that are attached to a package.
What is ibm db2 client?
Can there be more than one cursor open for any program?
What is difference between alias and synonym in db2?
What is a db2 table?
What is alias in db2?
What is image copy in db2?
What is db2 bind process?
What are the uses of db2 optimizer?
How do I delete a column in db2?
What is an instance in db2?
What db2 400?