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
- 5392 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
List down the types of triggers in the db2 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 .....
Which is faster delete or truncate?
How will you return the number of records in table?
What is dclgen in db2?
How to get the ddl of a table in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Highlight all the advantages that are attached to a package.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to find schema of a table in db2?
How does a cursor work?
How do I import data from excel to db2?
What is reorg and runstats in db2?
Describe major components of db2?
What is a db2 schema?
