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
- 7049 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 is cloudant database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is bind in db2?
What are the different types of base tables?
What is the difference between drop table and delete table?
What is ibm db2 connect?
What are the contents of a dclmgen?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a db2 collection?
How and when does the db2 enforces the unique key?
Why db2 is called db2?
Explain about rct in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How to access db2 tables in mainframe?
What is the latest version of ibm db2?
