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
- 7249 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
Explain dclgen.
Why do we use cursor?
How to rename a table in DB2 ?
Which components manage deadlocks in db2?
What is null indicator in db2?
How would the varchar column remarks defined?
What is load replace in db2?
What is scrollable cursor in db2?
What is blu acceleration in db2?
what are bind concepts in db2 cobol?
What is the difference between drop table and delete table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Are views updateable?
What is table space in db2?
what is db2 restart?
