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
- 6730 Views
- I also Faced
- E-Mail Answers
Answer Posted / scott
Use the COALESCE function
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What do you mean by rollback?
What are the two types of logging in the db2 database? Explain them.
Which is faster delete or truncate?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a db2 cursor?
What action db2 takes when a program aborts in the middle of a transaction?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the role of schema in the db2 database?
How do I optimize a query in db2?
What is meant by dclgen?
Mention data types used in db2 ?
What is null value in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the difference between cursor stability and repeatable read isolation levels?
