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?
Answer Posted / scott
Use the COALESCE function
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How connect db2 database to datastage?
What is the difference between cursor stability and repeatable read isolation levels?
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.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Can there be more than one cursor open for any program?
Explain correlated sub-queries.
What is the information associated with sysibm.syslinks table?
Mention the downsides of page level lock.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Explain various types of locks in db2?
What is the role of the data page in the db2 database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Give a brief description of db2 isolation levels?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is db2 bind?