Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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).

Answer Posted / krishna

declare the cursor with withhold option and we restart the
process from 111 record

Is This Answer Correct ?    3 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the bind parameters ibm db2?

1105


How to create backup table in db2?

1150


What action db2 takes when a program aborts in the middle of a transaction?

1197


How do I optimize a query in db2?

1152


What is check constraint in db2?

1165


What does db2 stand for?

1093


What is the usage of open cursor command?

1151


List out the three types of page locks that can be held.

1195


What is dbrm? What it contains?

1217


How do we specify index to include or not during bind process.

2178


Why do chiropractors use drop table?

1165


What is difference between isnull and coalesce?

1109


What is isolation level in db2?

1070


Define declaration generator (dclgen).

1172


Why do we need reorg in db2?

1047