Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is copy pending status in db2?
What is the difference between nvl and coalesce?
What are the prerogatives?
How do I add a column to a table in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What does runstats do in db2?
What is phantom read in db2?
What are concurrency issues?
What are the various isolation levels possible?
What is the use of commit in db2?
What is the result of open cursor statement?
List down the types of triggers in the db2 database?
What is db2 catalog database?
What are the contents of a dclmgen?
What is copy pending and check pending in db2?
