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 to execute stored procedures?

1129

What is null in db2?

1019

How to find primary key of a table in db2?

1061

What is cascading rollback?

1209

What is the physical storage length of time data type?

1123

What is db2 and what is the use of db2 optimizer?

1056

What does db2 mean?

1013

can all users have the privilage to use the sql statement select * (dml)?

1164

What is coalesce in db2?

1129

Explain what are the various isolation levels possible?

1041

What is the use of value function?

1147

What is meant by dclgen?

1103

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1158

Can there be more than one cursor open for any program?

1165

How to run db2 command in windows?

1191