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
Why cursor is used in db2?
What is deadlock in db2?
What does db2 mean?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are the contents of dclgen?
What action db2 takes when a program aborts in the middle of a transaction?
What is sqlca’s maximum length?
What is load utility in db2?
What is the maximum No of rows per page?
What are catalog tables in db2?
What is db2 stogroup?
What is netezza database?
what are bind concepts in db2 cobol?
What is lock escalation in db2?
Mention the various locks that are available in db2.