Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes?
- 4 Answers
- 7220 Views
- I also Faced
- E-Mail Answers
Answer Posted / kk
Hi,
Mostly we are using commit mass insert and update time
only.suppose i insert 1000 records i am using count varable
i give commit every 100th records means it will
automatically update the data base.so it will affect 999th
records means 900 records ulready update in ur table.so we
can restart 901 records thats enough.you can see in ur
table.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What does a deadlock mean in DB2?
What does db2 mean?
What is the physical storage length of the data types date, time, and timestamp?
What is the difference between oracle and db2?
Is db2 relational database?
What is the use of with ur in db2?
Mention the different locking levels that are available in db2.
What is the reason behind not using select * in embedded sql programs?
What is the role of the data page in the db2 database?
How would you find out the total number of rows in a db2 table?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How to restart a DB2 program?
What is difference between rollback and commit?
What is the physical storage length of time data type?
Explain dclgen.
