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...


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?

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

What are types of indexes?

0 Answers  


What is SPUFI?

4 Answers  


Explain about open switch business continuity software?

0 Answers  


Can you use max on a char column?

0 Answers  


in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,


in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,


can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  


how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,


Categories