For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

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 maximum number of columns in a db2 table?

0 Answers   IBM,

---

What is copy pending status in db2?

0 Answers  

---

What is meant by a unit of recovery?

1 Answers  

---

What is isolation level?

4 Answers  

---

When reorg is used?

0 Answers  

---

What are delete-connected tables?

1 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

Which is faster delete or truncate?

0 Answers  

---