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

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2432

What is schema in db2?

1079

What is iseries database?

1111

What is runstats utility in db2?

1066

What is copy pending and check pending in db2?

1036

How to restart a DB2 program?

1951

What are packages in db2?

1069

Give the name of some fields form sqlca.

1138

What is the difference between cursor and select statement?

1146

How to find the maximum value in a column in the db2 database?

1125

Who uses db2?

1108

What is dbrm?

1177

What is the maximum size of a char data type in db2?

1046

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1135

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1132