commit will insert a unit of work after some define number of record proc

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?

Question Posted / era

Answer Posted / era

commit will insert a unit of work after some define number
of record processed. That commit point will be taken and
the database updated.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I add a column to an existing table in db2?

977

What is cursor stability in db2?

1277

How can you classify the locks in db2?

1032

Explain the contents that are a part of dclgen.

1034

What is syscat in db2?

950

How would you find out the total number of rows in a db2 table?

989

Why do we bind in db2?

1140

What is dpf in db2?

1048

What is the meaning concurrency in the db2 database?

1056

Which isolation level provides maximum concurrency?

1089

What is the purpose of using commit?

1040

What is db2?

1124

What is the difference between db2 and oracle?

1068

Give the name of some fields form sqlca.

1022

How do I add a column in db2?

997