Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me about Restart logic in DB2.
- 2 Answers
- 7410 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 a db2 table?
What are foreign keys?
Give the name of some fields form sqlca.
How would you find out the total number of rows in a db2 table?
How many buffer pools are available in db2?
Define declaration generator (dclgen).
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
How can you get the number of rows impacted by the last executed query?
What is a DB2 plan?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is a buffer in memory?
COBOL 
