Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

What are column-name qualifiers used?

1 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---

What is a Database Request Module(DBRM)?

4 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

How to rename a table in DB2 ?

0 Answers   MCN Solutions,

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

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

2 Answers   HSBC, IBM,

---

What is the use of db2?

0 Answers  

---