Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

What is the max length of sqlca?

0 Answers  

---

what is utility for parm lib

0 Answers   IBM,

---

What is db2 optimizer?

0 Answers  

---

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

Are views updateable?

0 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---