Can any one tell me about Restart logic in DB2.
- 2 Answers
- 6544 Views
- I also Faced
- E-Mail Answers
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 cobol db2?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How do I import a csv file into db2?
If I have a view which is a join of two or more tables, can this view be updateable?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
How will you delete duplicate records from a table?
What is the difference between Where and Having Clause
How is a typical db2 batch pgm executed?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What does reorg do in db2?
what is + sign and -ve sign for sql code ?
COBOL 
