yep. With COALESCE we can

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 / keshireddy

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

Please Help Members By Posting Answers For Below Questions

How can record locking be achieved in those DB2 versions which do not support it?

1076

What is the use of predicate?

1041

What is role in db2?

1107

What db2 400?

1189

How does db2 sample database connect?

1028

How to check sequence on a table in db2?

1060

What is meant by union and union all?

1012

What os does db2 run on?

981

What is dbrm library?

1054

What is drop table?

1010

Explain packages.

1111

What is the meaning concurrency in the db2 database?

1110

What is cloudant database?

1096

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

What are packages in db2?

1023