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
- 7626 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehdee
- If you do COMMIT in your program, that means you have
UPDATE, INSERT or DELETE, which in this case you must
DECLARE CURSOR WITH HOLD, then it will not be closed after
COMMIT.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is with ur in db2?
What is null value in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is dclgen (declaration generator)?
How do I delete a column in db2?
What is netezza database?
What is the difference between oracle and db2?
What is difference between alias and synonym in db2?
What is db2 bind process?
How to fetch the last row from the table in SQL (db2)?
How to test SQL -911 error while developing COB-DB2 program
What is release/acquire in bind?
Explain about open switch business continuity software?
What is db2 command?
What is the difference between cursor stability and repeatable read isolation levels?
