Answer / sunil

while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing

Explain what are the various isolation levels possible?

0 Answers  

---

What is CHECK PENDING ?

5 Answers  

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

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,

---

What is DCLGEN?

2 Answers  

---

---

Update command

1 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

How do you stop a db2 database in linux?

0 Answers  

---