why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

What is reorg in DB2

3 Answers   Virtusa,

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

can we drop column from a table

7 Answers   INDUS,

---

What is a host variable?

3 Answers  

---

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

1 Answers   CTS,

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---