What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

What is a DB2 plan?

8 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

How to get the ddl of a table in db2?

0 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

---

What is the meaning of -805 SQL return code?

3 Answers  

---

How many buffer pools are there in DB2?

2 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

When is the skeleton cursor table created?

1 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

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,

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---