Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the use of value function?
what is the role of the cursor in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do you find the maximum value in a column in db2?
How to create backup table in db2?
How do I delete a column in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How would you find out the total number of rows in a db2 table?
Why cursor is used in db2?
What is the meaning concurrency in the db2 database?
Explain the contention situations caused by locks?
List out the buffer pools in db2
How to connect to db2 database from windows command line?
Why do we bind in db2?
List down the data types in the db2 database.
