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

What is the result of open cursor statement?

636


How to take backup of table in db2?

599


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1574


How to find the maximum value in a column in the db2 database?

605


How do I connect my db2 database to ibm?

600






What is a buffer in memory?

596


What is bind package and plan in db2?

591


What is bind in db2?

604


is it compulsory commitment control in journal?

2009


How to run db2 command in windows?

643


What is explain in db2?

582


What are the various isolation levels possible?

647


What is reorg and runstats in db2?

692


What is a cursor in programming?

594


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

626