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...

Suppose we are doing transaction in a table and abend happened in
between. Suppose i have completed the transaction upto X rows and
I want to start the transaction again where the abend happened. I
don't want to do the transaction from the first record. Then what
i have to do.

Answer Posted / k.pratap

using flags.we correct that one.
first insert flag in u r table.
first write in u r cursor declaration with flag=0.
first take flag is 0.
after read the record.if record is successfully reading update flag is 1.ok.
if abend coming automatically rollback applied.
next the cursor going where the flag=0.it means it not successfully updated.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Comment whether the cursor is closed during commit or not.

1105


How does cobol compile db2 program?

1055


How to view db2 table structure?

1017


What is view db2?

1076


What is the use of value function?

1150


What is data manager?

1049


Explain about mirror activator disk mirroring?

1009


i want to maintain uniqueness on pdf without make lf??????????

2155


What are the 2 sqlcodes that are returned?

1189


What is a db2 package?

1056


Name the various locking levels available?

1091


How to find primary key of a table in db2?

1065


What is the difference between plan and package in db2?

1112


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240


My sql statement select avg(salary) from emp yields inaccurate results. Why?

1092