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


Please Help Members By Posting Answers For Below Questions

What is the difference between dbm cfg and db cfg file in db2 ?

1269


What is the max length of sqlca?

967


What is runstats db2?

774


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

957


What is a db2 collection?

803


How to rename a table in DB2 ?

822


Mention the various locks that are available in db2.

792


When the like statement is used?

887


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

1832


When reorg is used?

866


How many databases are there?

788


Can there be more than one cursor open for any program?

912


What is a page in db2?

800


What is db2? Explain.

790


What is a db2 cursor?

809