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 in my table 10 rows are there , i want to update odd
rows salary as 90000 ? how u do it ? any one help me ? what
do we use here cursor-fetch or normal sql ?

Answer Posted / saurabh

It can be achieved using the scroll able cursor along with the Relative option while updating the queue.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you concatenate the firstname and lastname from emp table to give a complete name?

1016


What are the various isolation levels possible?

1051


How do I create a view in db2?

976


What is the use of value function?

1076


What is db2 instance?

1018


What is the latest version of ibm db2?

1203


How do you find the maximum value in a column in db2?

1056


How to restart a DB2 program?

1829


What is a db2 table?

958


What is package in cobol db2?

1078


Mention the definition of cobol in varchar field.

1180


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9002


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114


What is dbrm? What it contains? When it will be created?

994


What is a db2 collection?

982