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
- 7420 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 phantom read in db2?
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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What do you mean by rollback?
Where do you specify them?
What is the picture clause of null indicator variable?
What is db2 command?
Before you give the explain statement, what are the prerogatives?
How to access db2 tables in mainframe?
Which isolation level provides maximum concurrency?
What is the difference between spufi and qmf?
What do you mean by cursor?
What is explain plan in db2?
What db2 400?
What is access path in db2?
