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
What is the difference between dbm cfg and db cfg file in db2 ?
What is the max length of sqlca?
What is runstats db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a db2 collection?
How to rename a table in DB2 ?
Mention the various locks that are available in db2.
When the like statement is used?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
When reorg is used?
How many databases are there?
Can there be more than one cursor open for any program?
What is a page in db2?
What is db2? Explain.
What is a db2 cursor?