Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / shefali799

Answers were Sorted based on User's Feedback



For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / scott

Use the COALESCE function

Is This Answer Correct ?    7 Yes 0 No

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / keshireddy

yep. With COALESCE we can

Is This Answer Correct ?    1 Yes 0 No

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / sankar

You can also use VALUE

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

How to get the ddl of a table in db2?

0 Answers  

What does a deadlock mean in DB2?

0 Answers  

What is access path in db2?

0 Answers  

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

What are the three types of page locks that can be held?

1 Answers  

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

Which components manage deadlocks in db2?

0 Answers  

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

For more DB2 Interview Questions Click Here
Categories