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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!