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

Is db2 a programming language?

985


How can record locking be achieved in those DB2 versions which do not support it?

1021


What is image copy in db2?

946


Describe major components of db2?

1044


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1103


What is ibm db2 used for?

1005


What is a page in db2?

982


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2024


Explain the function of data manager.

993


Define db2 and its databases?

1006


What is the difference between oracle and db2?

1033


What is sqlca?

1001


What does reorg do in db2?

985


What is the picture clause of null indicator variable?

1083


What are catalog tables in db2?

982