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.

What is dynamic SQL?

1 Answers   ADP,

---

What does db2 blu stand for?

0 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What is the use of commit in db2?

0 Answers  

---

---

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  

---

What is db2 instance?

0 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

How many types of page locks can be held in db2?

0 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---