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 db2 bind?
What type of database is db2?
What is the clustering index in the db2 database?
How do I add a column in db2?
What is db2 look?
What is check constraint in db2?
Is db2 free?
What is cursor with hold option in db2?
What is a system catalog table in db2?
Explain about rct in db2?
What is cursor stability in db2?
can we view the access paths created by dbrm ? how ? thx
Explain about mirror activator disk mirroring?
What is the maximum No of rows per page?
List out the data types available.
