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 do I delete a table in database?
What is dbrm library?
How does db2 sample database connect?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a plan and package in db2?
How can you classify the locks in db2?
Define sqlca.
How do you eliminate duplicate values in db2?
What is ibm db2 connect?
What is explain plan in db2?
What is innodb buffer pool?
How do you pull up a query which was previously saved in qmf?
Which command is used to remove all rows from a table?
What are the contents of a dclmgen?
what is diffrence b/w file-aid tool and file-aid utility???