OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

What are delete-connected tables?

1 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

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

0 Answers   MCN Solutions,

---

What is a host variable?

3 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

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  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

What is a thread?

3 Answers  

---

Explain package in db2 and its advantages?

0 Answers  

---