Interested to Buy Any Domain ? << Click Here >> for more details...
what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 15024 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / harish
yes, commit-it will save the changes that we done to db2
table
when operation is performed successfully table will be auto
committed its default,suppose if any abends occur all
changes will be rolled back , table will come to original
status
since while updating millions of records somewhere some
abend occurs that time its better to have commit ,so till
upto abend whatever changes occured in table will be
saved.....
pls let me know if u have any queries
HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different types of base tables?
What is db2 purescale?
What is explain plan in db2?
What is the difference between plan and package in db2?
How many databases are there?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How many types of page locks can be held in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How to execute stored procedures?
What is the difference between using bind () and rebind () methods of naming class?
What is db2 connect?
What type of database is db2?
How can you find out the # of rows updated after an update statement?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the difference between drop table and delete table?
