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?
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 do you mean by commit and rollback?
What is a plan and package in db2?
What is a trigger in the db2 database?
What is db2 stogroup?
Explain correlated sub-queries.
i want to maintain uniqueness on pdf without make lf??????????
What does runstats do in db2?
What are iseries servers?
What is the maximum size of varchar data type in db2?
Are view updateable?
What is buffer pool in the db2 database?
What do you mean by rollback?
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 runstats utility in db2?
What are the various data types available in db2?