Use the COALESCE function

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?

Question Posted / scott

3 Answers
6864 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

Please Help Members By Posting Answers For Below Questions

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1127

What is collection in db2 bind?

1059

What is view db2?

1127

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1138

Define buffer pool.

1097

Is it possible using max on a char column?

1189

What is bufferpool in db2?

1093

What is meant by explain?

1190

What is the usage of open cursor command?

1143

How will you return the number of records in table?

986

How do I delete a column in db2?

1152

What is db2 and what is the use of db2 optimizer?

1108

Can we update view in db2?

1051

what is the sqlcode -501

13296

What are the different types of base tables?

1157