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 is reorg?

619


How to find the number of rows in db2 tables?

617


Mention some fields that are a part of sqlca.

603


What is meant by explain?

660


What is bind plan?

610






What does db2 mean?

587


Define check constraint.

644


What is meant by union and union all?

586


How to connect to db2 database from windows command line?

562


My sql statement select avg(salary) from emp yields inaccurate results. Why?

641


How to check sequence on a table in db2?

600


What is the physical storage length of date data type?

728


what is utility for parm lib

1876


What is db2 purescale?

548


What is the usage of open cursor command?

599