Answer / sravani

when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)

Is db2 a programming language?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

---

What is the use of db2 optimizer?

0 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

Can there be more than one cursor open for any program?

0 Answers  

---

Describe major components of db2?

0 Answers  

---

What is subquery ?

6 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---