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 is the value function used?
What is the maximum size of a char data type in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is runstats and reorg in db2?
What is buffer pool in the db2 database?
What is null in db2?
How to run db2 command in windows?
What is dbrm in db2 database?
What is package in cobol db2?
Why select is not preferred in embedded sql programs?
How do I delete a column in db2?
How do you eliminate duplicate values in db2?
What is a dbrm in db2?
What is image copy in db2?
B37 abend during spufi?