Can we update view in db2?

0 Answers  

---

What is cursor stability?

1 Answers  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

---

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

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

2 Answers   CGI, Value Labs,

---

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 are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---