We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows:
update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin
gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0)
Previously this returned the following result:
674 rows updated in MSPMP100 in GRMLIB.
But now the same command returns:
Null values not allowed in column or variable PMFP2.
Any help much appreciated.