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.

2 Answers   Syntel,

---

Why cursor is used in db2?

0 Answers  

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What is reorg in database?

1 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

When reorg is used?

0 Answers  

---

What is COPY PENDING status?

6 Answers  

---

What is the role of schema in the db2 database?

0 Answers  

---