query bombs after Operating System upgrade

[lespaul]

We upgraded our iSeries operating system over the weekend. The following query has been used successfully over the past 6 months or so and is now broken. Can anyone tell me what they think might be the issue?

SELECT c.CHKINTIME, p. HERTIM, p.HERTYP, p.CASPRE, p.CASNUM, p.JUDNM, p.OFFCR,
       p.OFFNUM, p.MAGENC, c.MESSAGE, c.CHKINDATE, 
       LEFT( c.MESSAGE, 20) As "Info", d.DEFNAM, c.MSGDATE, c.MSGTIME,
       c.MSGSOURCE          
FROM plobjlib/plpoffhr p, cmlib/cmpdefmf d
LEFT OUTER JOIN CMVCHKINS c
ON c.OFFNUM = p.OFFNUM and c.MAGENC = p.MAGENC and c.CHKINDATE = p.HERNGDAT
WHERE p.HERNGDAT = 20051017 and p.CRTROM = 640 and
      ((NOT c.CHKINTIME IS NULL) OR c.MESSAGE <> '')  and 
      (p.stscde = '8' or p.stscde = '9' ) and 
      p.HERTIM BETWEEN 700 AND 1800 and
     p.CASPRE = d.CASPRE and p.CASNUM = d.CASNUM

(one of my co-workers wrote the query, I prefer declared joins to cartesian!!)

Error message is:

Invalid Expression.
Data conversion or data mapping error.

The fields message and info are both blob fields in case that may make a difference.

Any assistance appreciated!

Thanks!

Leslie

 

[lespaul]

disregard, not a query problem after all.