Answer / sravani

using INTRDR

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What are the contents of a dclmgen?

0 Answers  

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

What is a predicate?

1 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What does db2 stand for?

0 Answers  

---

Why do we bind in db2?

0 Answers  

---

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 buffer pool in the db2 database?

0 Answers  

---

What is the latest version of ibm db2?

0 Answers  

---