Can any one tell me about Restart logic in DB2.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / muneer
suppose if we have 1000 records while retriving data we got
abend at any stage we will use restart logic.this is the
basic idea of restart logic...
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the difference between drop table and delete table?
What is universal database?
How will fetch last 5 rows from table in db2
What is sqlca?
What is the function of logging in the db2 database?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What techniques are used to retrieve data from more than one table in a single SQL statement?
how to resolve -811 sqlcode .give clear explaination
What is the meaning concurrency in the db2 database?
What is a LIKE table and how is it created?
What is check constraint in db2?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?