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
Define predicate?
What happens in bind step in a db2 program?
What do you mean by cursor?
What is multi row fetch in db2?
What is node in db2?
Is db2 a database?
can all users have the privilage to use the sql statement select * (dml)?
How can we retrieve the total number of records in RPG & CLLE?
How is deadlock resolved?
What r the comman abends in db2, jcl and cobol???????
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the clustering index in the db2 database?
What is a db2 cursor?
Which component is responsible for db2 startup and shutdown?
What is the purpose of using commit?