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
- 5363 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
You can also use VALUE
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How is deadlock resolved?
What is db2 plan table?
What is the physical storage length of timestamp data type?
What is null value in db2?
Give the name of some fields form sqlca.
what is utility for parm lib
What is syscat in db2?
Name the various locking levels available?
Explain dclgen.
Explain package in db2 and its advantages?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to get the ddl of a table in db2?
Define buffer pool.
Why do we bind in db2?
How can record locking be achieved in those DB2 versions which do not support it?
