What are column-name qualifiers used?

1 Answers  

---

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

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,

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---

Can I use LOCK TABLE on a view?

1 Answers  

---

How to update more then one record using update?

5 Answers   IBM,

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---