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 syscat in db2?
What are union and union all?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the use of db2?
Mention the various locks that are available in db2.
B37 abend during spufi?
What is the use of value function?
What is db2 purescale?
How many databases can be created inside an instance in db2 ?
What is dbrm in db2 database?
Can we insert update delete in view?
Where can you declare a cursor in a cobol-db2 program?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is ibm db2 used for?
What is db2 and what is the use of db2 optimizer?