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

2 Answers
12442 Views
Syntel, I also Faced
E-Mail Answers

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

How to retrieve rows from a db2 table in embedded sql?

1393

Explain in detail about buffer manager and its functionalities?

1067

What is rebind in db2?

1069

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3212

What is the use of value function?

1151

Explain about rct.

1089

What is the use of runstats in db2?

1112

What is rct?

1236

Explain what are the various isolation levels possible?

1044

What is the difference between cursor and select statement?

1106

What is ibm db2 connect?

1002

What is reorg and runstats in db2?

1219

When do you specify the isolation level?

1032

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2067

Which components manage deadlocks in db2?

1071