Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6585 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
Are views updateable?
What are the two types of logging in the db2 database? Explain them.
Define check constraint.
Is the primary key a clustered index?
Can we delete records from view?
What is table space in db2?
What is the use of db2 optimizer?
Is db2 a database?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is clone table?
what is the sqlcode -501
What is a buffer in memory?
How do I create a view in db2?
What is ibm db2 database?
What happens in bind step in a db2 program?
