Interested to Buy Any Domain ? << Click Here >> for more details...
I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again).
- 10 Answers
- 58748 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pradeep
CHECKPOINT-RESTART logic is used when your pgm performs
large no of database updates or inserts. If checkpoint
frequency has been set to 100, then on RESTART the pgm will
start processing from 101 record without restart from
starting.
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is db2? Explain.
What are catalog tables in db2?
What is view db2?
Which isolation level provides maximum concurrency?
Mention some fields that are a part of sqlca.
Explain the contention situations caused by locks?
Explain how can you do the explain of a dynamic sql statement?
What is null indicator in db2?
How to retrieve rows from a db2 table in embedded sql?
What are bind parameters in db2?
How to connect to db2 database from windows command line?
List out the data types available.
How to fetch the last row from the table in SQL (db2)?
What is buffer pool?
