what is the syntax for FOR UPDATE CLAUSE in cursor
declaration and how can u update using cursor? is it
possible to update multiple rows at a time.

Answer Posted / vaneesh khurana

If one wants to update multiple rows simply write a querry,
instead of using cursor.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by rollback?

651


What are the various data types available in db2?

711


What are the prerogatives?

701


Which component is responsible for db2 startup and shutdown?

712


What are the uses of db2 optimizer?

916






What are host variables in db2?

707


What is the maximum size of a char data type in db2?

672


How do you pull up a query which was previously saved in qmf?

778


Outputs of explain are with matchcols = 0. What does this signify?

709


What is a trigger in the db2 database?

669


What is multi row fetch in db2?

677


What is the use of value function?

728


How do I connect my db2 database to ibm?

672


Explain correlated sub-queries.

663


Define buffer pool.

706