Why do we use cursor?

0 Answers  

---

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

0 Answers  

---

What are types of indexes?

0 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

How is the value function used?

0 Answers  

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

What is dpf in db2?

0 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

what are the bind parameters?

5 Answers   IBM,

---

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  

---