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?

Answers were Sorted based on User's Feedback



For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / scott

Use the COALESCE function

Is This Answer Correct ?    7 Yes 0 No

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / keshireddy

yep. With COALESCE we can

Is This Answer Correct ?    1 Yes 0 No

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / sankar

You can also use VALUE

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


How to check sequence on a table in db2?

0 Answers  


What are leaf pages?

3 Answers  


Which transaction use a command thread ?

1 Answers  


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  


What are concurrency issues?

0 Answers  


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  


What is the default page size of buffer pools?

0 Answers  


Who uses db2?

0 Answers  


Categories