Upgrade OS from V4R5 to V5R2 and SQL stopped working

0 pts.
Tags:
Database
DB2 Universal Database
Hi, 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.
ASKED: October 18, 2005  6:42 AM
UPDATED: October 18, 2005  11:33 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In 2003 we migrated from V4R5 to V5R2 and had SQL “issues”. Can’t remember exactly what they were but I have an archived email that says the solution was the deletion of QGPL/QZDAPKG *SQLPKG. Once deleted this is recreated by QUSER and solves the problem – whatever that may be.

Apologies for the rather un-specific help but it might solve your issue – it can only still fail, right!!!

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • NJShoreBob
    I had a similar experience with this issue when upgrading to 5.1. The program would run fine, but would return no data. When I spoke to IBM, they said two things. One was to make sure that you are using the physical file not the logical, and the other was that they made a change to the iSeries SQL. They had me change a system setting file (via DFU). This would have the operating system work the 'old way' (previous release). I forget what the actual system file was...( I have changed jobs and it was at the other company...sorry!) I'd call IBM......Hope this helps..
    0 pointsBadges:
    report
  • TheQuigs
    Is there definitely a value in SINGUPL2 for each record in MSPMP100? If not, the subselect will return a null value which is evidently not allowed in MSPMP100.PMFP2. If you add the following where clause to your update, it should eliminate the possibility of no records in SINGUPL2 for the MSPMP100 records: 'WHERE EXISTS (SELECT * FROM GRMLIB/SINGUPL2 T3 WHERE T3.PRDNO = T1.PRDNO AND T3.PMFP20)' hth
    0 pointsBadges:
    report
  • GREGOR8
    Thanks, this did the trick: If you add the following where clause to your update, it should eliminate the possibility of no records in SINGUPL2 for the MSPMP100 records: 'WHERE EXISTS (SELECT * FROM GRMLIB/SINGUPL2 T3 WHERE T3.PRDNO = T1.PRDNO AND T3.PMFP20)' It always worked at V4R5, guess they've changed how it operates and it's now more particular than it used to be.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following