Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7802 Views
- I also Faced
- E-Mail Answers
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 to take backup of table in db2?
Define predicate?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Explain dclgen.
Explain various types of locks in db2?
What is bufferpool in db2?
Which components manage deadlocks in db2?
Where can you declare a cursor in a cobol-db2 program?
How to fetch the last row from the table in SQL (db2)?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the syntax for creating a table in the db2 database?
What is role in db2?
what is a corelated subquerry?
Are views updateable?
What is the latest version of ibm db2?
