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

Explain in brief how does db2 determine what lock-size to use?

1024

What is catalog database in db2?

1145

What is innodb buffer pool?

1030

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11663

How many databases are there?

1036

How do I delete a table in db2?

1053

List some fields from sqlca?

1039

Explain dclgen.

1180

What is the role of data manager in the db2 database?

1093

What is rct?

1210

Give a brief description of db2 isolation levels?

1048

Explain package in db2 and its advantages?

1190

What is dclgen (declaration generator)?

1036

What is declare cursor?

1104

What is db2 catalog database?

1021