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 innodb buffer pool?
What is alias in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How to find the maximum value in a column in the db2 database?
What is cursor stability in db2?
What is coalesce in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Outputs of explain are with matchcols = 0. What does this signify?
Can there be more than one cursor open for any program?
can all users have the privilage to use the sql statement select * (dml)?
What is the use of commit in db2?
What is drop table?
What is the maximum size of varchar data type in db2?
Explain what are the various isolation levels possible?
What is ibm db2 database?
