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

How to update more then one record using update?

Answer Posted / selvam a

Update a table using a symbolic cursor:
UPDATE WHERE CURRENT OF limits the scope of DB2 updates to
one row at a time, specifically the row your cursor is
positioned on.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we update view in db2?

1007


Which components manage deadlocks in db2?

1074


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2072


Explain various types of locks in db2?

1160


How can the duplicate values be eliminated from db2 select?

1107


What is phantom read in db2?

1167


What is precompiler in db2?

1026


When do you specify the isolation level?

1040


What is dbrm?

1113


How connect db2 database to datastage?

1249


What is null value in db2?

1032


How do I add a column to a table in db2?

1107


What is a db2 tablespace?

1072


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1279


How do I delete a table in database?

1030