db2 restart logic ?

Answer Posted / ankitha

declare temp table with fields pkey and commit frequency.
then set commit frequency ie after 100 records it should
tabulate the temp table and in procerdure division read the
last pk value and should start updating after that pk value
and should delete this temp tble after the final commit or
stop run.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 package?

599


Is db2 free?

684


What is the difference between db2 and oracle?

680


What is copy pending and check pending in db2?

578


Explain about cursor stability?

623






Why do chiropractors use drop table?

662


What is db2 optimizer?

771


What is a trigger in the db2 database?

596


What are the different types of base tables?

587


Explain the benefits you can get from mainframe connect?

522


How can you count the number of rows from a table tab?

638


What is a page in db2?

611


What is the maximum size of a char data type in db2?

588


What is a db2 tablespace?

602


What is null indicator in db2?

604