Thanks! We'll email you
when relevant content is
added and updated.
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.
October 18, 2005 6:42 AM
October 18, 2005 11:33 AM