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
- 7784 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 precompiler in db2?
What are the full forms of spufi and dclgen and why are they used?
What is load replace in db2?
What is db2 catalog database?
What kind of database is db2?
What is deadlock in db2?
What is dclgen (declaration generator)?
What is a bind card?
what is the responsibility of the construction superintendent
Explain about open switch business continuity software?
How can you do the explain of a dynamic sql statement?
Is the primary key a clustered index?
Is db2 free?
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.
Is db2 a programming language?
