You can also use VALUE

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 / sankar

3 Answers
6631 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

Please Help Members By Posting Answers For Below Questions

Give a brief description of db2 isolation levels?

1033

What is the maximum No of rows per page?

1028

Is db2 free?

1047

How can we retrieve the total number of records in RPG & CLLE?

601

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1124

How to connect to db2 database from windows command line?

1020

What is cursor with hold option in db2?

1031

What is check constraint in db2?

1029

What is copy pending status in db2?

1084

What is a dbrm in db2?

982

What is db2 instance?

1036

How do I add a column to an existing table in db2?

992

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1244

What is the maximum size of varchar data type in db2?

1084

How to find schema of a table in db2?

976