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).
Answer Posted / krishna
we have restart logic in DB2
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
Which is faster delete or truncate?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is alias in db2?
What is a db2 tablespace?
What is db2 purescale?
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.
How do I connect my db2 database to ibm?
How do I copy a table in db2?
What is the role of schema in the db2 database?
How and when does the db2 enforces the unique key?
How do you find the maximum value in a column in db2?
How can you find out the # of rows updated after an update statement?
What is db2 catalog database?
What language is db2 written in?