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

What is the maximum length of sqlca?

1512

Where do you specify them?

1260

How many types of page locks can be held in db2?

1031

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4294

How to compare data between two tables in db2?

1076

What is a storage group (stogroup)?

1239

Why do we bind in db2?

1202

How do I add a column in db2?

1041

Are views updateable?

1144

Why do we use cursor?

1091

What are db2 tables?

1108

How is a typical db2 batch pgm executed?

1167

What is dbrm in db2 database?

1103

What is db2 instance?

1065

What is package in cobol db2?

1113