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

How to find primary key of a table in db2?

1052

What is the physical storage length of timestamp data type?

1084

What do you mean by storage group (stogroup)?

1031

How to find schema of a table in db2?

1006

what is the responsibility of the construction superintendent

2137

Define buffer pool.

1039

What is database reorganization?

1114

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1270

What are the 2 sqlcodes that are returned?

1181

When the like statement is used?

1217

What is load replace in db2?

986

What is a bind card?

1208

What r the comman abends in db2, jcl and cobol???????

2250

List down the types of triggers in the db2 database?

1014

What is the use of db2 optimizer?

1098