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
When reorg is used?
What is the use of commit in db2?
How to resolve deadlock issue
What is phantom read in db2?
What does db2 plan contain?
What is copy pending status in db2?
What is precompiler in db2?
How would you find out the total number of rows in a db2 table?
What is a dbrm in db2?
What is view db2?
Define check constraint.
What is the difference between cursor stability and repeatable read isolation levels?
What is a buffer in memory?
What are db2 tables?
List out the buffer pools in db2