Answer / Jaideep Shrivastava

The VALUE function in DB2 returns a single row result set containing a scalar value. It's often used with SQL functions and system functions to retrieve values.

What is bufferpool in db2?

1 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 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,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

What is meant by AUTO COMMIT?

3 Answers  

---

What does runstats do in db2?

1 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---