Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6742 Views
- I also Faced
- E-Mail Answers
Answer Posted / scott
Use the COALESCE function
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
How can we retrieve the total number of records in RPG & CLLE?
What is a system catalog table in db2?
What is dclgen (declaration generator)?
What are the benefits of using the db2 database?
Define declaration generator (dclgen).
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Which components manage deadlocks in db2?
What does db2 plan contain?
What is ibm db2 connect?
define clustering index.
What is the reason behind not using select * in embedded sql programs?
Why do we bind in db2?
What is cobol db2?
Explain the function done by data manager?
