Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me about Restart logic in DB2.
- 2 Answers
- 7162 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 |
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Where would you find information about the type of database authority held by the user?
What is db2 bind process?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What does reorg do in db2?
What are the various data types available in db2?
what is difference between Plan and Package
What is bind in db2?
what happend with out using Commit,when closing cursor and program?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
COBOL 
