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 runstats db2?
What is the use of db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is drop table?
What is db2 connect?
What is db2 plan table?
What is access path in db2?
What happens in bind step in a db2 program?
What type of database is db2?
Explain about cursor stability?
What is copy pending status in db2?
What is the difference between spufi and qmf?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the role of schema in the db2 database?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well