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
- 7627 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
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Can we update view in db2?
can we view the access paths created by dbrm ? how ? thx
What is database reorganization?
what is the responsibility of the construction superintendent
What is meant by dclgen?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the use of value function?
How do I add a column to a table in db2?
Which isolation level provides highest data integrity?
How to create backup table in db2?
i want to maintain uniqueness on pdf without make lf??????????
How would you find out the total number of rows in a db2 table?
Define db2 and its databases?
When reorg is used?
