Answer Posted / girish kumar
suppose if we have 1000 rows for update, while we updating
incase if we get abend occures at 999 even a single record
could not be saved to database with out execute commit.
so that if we can place a commit for every 100 records
incase abend occres at 999 cursor start for 900 onwords by
issuing rollback along with commit.
this is db2 logic better to refer MUTTU REFRESHNER
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain in detail about buffer manager and its functionalities?
On which levels locks can be applied?
How do I copy a table in db2?
What is a bind card?
What is buffer pool?
How to find schema of a table in db2?
What is collection in db2 bind?
Which isolation level provides highest data integrity?
what are bind concepts in db2 cobol?
What is a db2 tablespace?
can all users have the privilage to use the sql statement select * (dml)?
How do I add a column in db2?
Outputs of explain are with matchcols = 0. What does this signify?
How do I import a csv file into db2?
What db2 400?