can we update the table by using cursors can anyone post
the query?

Answer Posted / bigben

yes you can
declare cursor using FOR UPDATE option

Is This Answer Correct ?    23 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the role of the cursor in db2?

643


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

614


List down the data types in the db2 database.

636


What are the benefits of using the db2 database?

662


What is coalesce in db2?

682






What is a system catalog table in db2?

589


How do I start db2 in windows?

567


What is db2 catalog database?

582


How do I connect my db2 database to ibm?

602


What is a Foreign Key?

658


How can you count the number of rows from a table tab?

638


Can you tell me how can you find out the # of rows updated after an update statement?

612


Which isolation level provides maximum concurrency?

666


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624


How many databases are there?

592