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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we specify index to include or not during bind process.

1672


List down the data types in the db2 database.

630


On which levels locks can be applied?

652


Highlight all the advantages that are attached to a package.

623


How do you stop a db2 database in linux?

564






What is a storage group (stogroup)?

772


Define buffer pool.

618


What is the maximum number of columns in a db2 table?

714


What is the maximum size of varchar data type in db2?

643


Explain the contents that are a part of dclgen.

651


Which component is responsible for db2 startup and shutdown?

622


What is alias in db2?

563


What is rct?

747


What is difference between alias and synonym in db2?

635


What is buffer pool?

607