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

Outputs of explain are with matchcols = 0. What does this signify?

854


How can you classify the locks in db2?

860


What are the contents of dclgen?

875


How do you select a row using indexes in db2?

870


What is the difference between plan and package in db2?

859


what is the sqlcode -501

12205


How do I import data from excel to db2?

850


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2701


What is the information associated with sysibm.syslinks table?

900


Which isolation level provides maximum concurrency?

923


How to check last update on table in db2?

839


What is null in db2?

776


List out the three types of page locks that can be held.

932


What is db2 bind process?

964


What is the cobol picture clause of the db2 data types date, time, timestamp?

860