Outer join for DB2 V6 s/390

[legend8]

I've a complex view that use some LEFT OUTER JOINs and then the view is being used again and create another view using some RIGHT OUTER JOINs. The final view is working fine (slow but at least it runs) until we upgraded DB2 from 5 to 6. Whenever the view was dropped and recreate again in V6, it hangs and the thread will never go away.

Any idea is much appreciated.

 

[Crox]

Perhaps the boys from MVSHELP know something about this:

http://mvshelp.com/cgi-bin/ubbcgi/f...B2,+SQL,+QMF&number=2&DaysPrune=10&LastLogin=

Regards,

Crox