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
- 6871 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
What is the use of with ur in db2?
How would you find out the total number of rows in a db2 table?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the use of value function?
is it compulsory commitment control in journal?
Where do you specify them?
What is the maximum size of varchar data type in db2?
What are db2 tables?
What is a Foreign Key?
What is difference between isnull and coalesce?
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 .....
Can one database have multiple instances?
Is db2 a mainframe database?
What is the physical storage length of time data type?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
