Answer / s

DB2 uses multiple index processing by using the technique
called list prefetch. The qualifying RIDS from all the
indexes in placed in the RID Pool, sorted and duplicate
RIDS are eliminated based on the page number and List
prefetch I/O issued to read the data pages in DASD
sequence.

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

On which levels locks can be applied?

0 Answers  

---

What is index in db2?

1 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

How would you find out the total number of rows in a db2 table?

0 Answers  

---

What is buffer pool and list some of them?

0 Answers  

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---

What is dclgen in db2?

0 Answers  

---