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

Define predicate?

0 Answers  


List out the data types available.

0 Answers  


When the like statement is used?

0 Answers  


Is ibm db2 open source?

0 Answers  


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,






Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  


What is an instance database?

0 Answers  


Give a brief description of db2 isolation levels?

0 Answers  


Is db2 a database?

0 Answers  


What is RUNSTATS?

3 Answers  


What are the disadvantages of PAGE level lock?

3 Answers  


how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,


Categories