I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

---

---

Define sqlca.

0 Answers  

---

what are extents?

5 Answers  

---

What is declare cursor?

0 Answers  

---

What are the advantages of using a PACKAGE?

2 Answers  

---

What is reorg and runstats in db2?

0 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

What is null indicator in cobol db2?

0 Answers  

---