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
- 58047 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
What is the difference between cursor stability and repeatable read isolation levels?
what is the role of the cursor in db2?
What is dbrm library?
Explain packages.
What are the rules for db2 programming?
Which are the db2 tools to protect integrity of the database?
Why do we bind in db2?
can all users have the privilage to use the sql statement select * (dml)?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are union and union all?
How to rename a table in DB2 ?
What is plan in cobol db2?
What is a plan and package in db2?
What is a db2 cursor?
What is ibm db2 connect?
