Oppolzer - Informatik / Blog

Hi DB2-List,

we migrated to V7 (OS/390) this week.

We have problems with some chains of outer joins, for example

select ...
from t1
left join
t2
on ...
left join
t3
on ...
left join
t4
on ...
left join
t5
on ...

In some cases, we get NULL values from t4 and/or t5, although there are
matching rows in these tables (with respect to the ON conditions).

If we replace the left joins with inner joins, we get the correct results (but
we are missing some REAL null rows, of course).

We tried it once more on our production system, which is still V6, and all
performed well.

Did someone also see effects like this ?
Are there APARs or PTFs we could apply ?

Regards

Bernd