what happend with out using Commit,when closing cursor and
program?
Answer Posted / mani
The answer to the question is pretty simple and straight.
Auto commit happens when the cursor is closed.
If at all there is any abend then the changes made will be lost.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How do I copy a table in db2?
can all users have the privilage to use the sql statement select * (dml)?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Name the various locking levels available?
How is the value function used?
Where do you specify them?
How to check last update on table in db2?
What is bind in db2?
What is null in db2?
Is it possible using max on a char column?
Explain how can you do the explain of a dynamic sql statement?
What is the difference between drop table and delete table?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is multi row fetch in db2?