What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

How to execute stored procedure in db2 command editor?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What is the use of value function?

0 Answers  

---

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,

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What will the DB2 optimizer do?

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

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

What is a DB2 access path?

1 Answers  

---

What is a cursor and what is its function?

2 Answers  

---