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?
Answer Posted / sankar
You can also use VALUE
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is sqlca?
What is the max length of sqlca?
What is explain in db2?
What is null indicator in cobol db2?
What does db2 plan contain?
What is the use of with ur in db2?
How do I connect my db2 database to ibm?
What is netezza database?
Explain dclgen.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How would the varchar column remarks defined?
Which isolation level provides maximum concurrency?
What is runstats and reorg in db2?
What is the physical storage length of date data type?
Define data page.