If one wants to update multiple rows simply write a querry, instead of us

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.

Question Posted / vaneesh khurana

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

Please Help Members By Posting Answers For Below Questions

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

1108

What do you mean by commit and rollback?

1085

What is db2 command?

1088

How to connect to db2 database from windows command line?

1128

How to find schema of a table in db2?

1063

Who uses db2?

1110

What are the contents of a dclmgen?

1176

What is check constraint in db2?

1163

What is host variable in db2 cobol?

1130

What is null in db2?

1068

What is dclgen in db2?

1194

What is sqlca?

1128

What are catalog tables in db2?

1104

What is a buffer in memory?

1107

How can record locking be achieved in those DB2 versions which do not support it?

1122