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
Outputs of explain are with matchcols = 0. What does this signify?
How can you classify the locks in db2?
What are the contents of dclgen?
How do you select a row using indexes in db2?
What is the difference between plan and package in db2?
what is the sqlcode -501
How do I import data from excel to db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the information associated with sysibm.syslinks table?
Which isolation level provides maximum concurrency?
How to check last update on table in db2?
What is null in db2?
List out the three types of page locks that can be held.
What is db2 bind process?
What is the cobol picture clause of the db2 data types date, time, timestamp?