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
- 5382 Views
- I also Faced
- E-Mail Answers
Answer Posted / keshireddy
yep. With COALESCE we can
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the use of db2 optimizer?
On which levels locks can be applied?
What is null value in db2?
How can you do the explain of a dynamic sql statement?
what is diffrence b/w file-aid tool and file-aid utility???
Which component is responsible for processing sql statements and selecting access paths?
How do I add a column to an existing table in db2?
What are iseries servers?
How to find the number of rows in a db2 table?
What is database manager in db2?
What is host variable in db2 cobol?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How does cobol compile db2 program?
What is the role of the data page in the db2 database?
