How Plan is created while executing the query using SPUFI?

3 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

What is access path in db2?

0 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What are host variables in db2?

0 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

What is buffer pool?

0 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---