You might want to consider sharing the name of tool that you are using to execute your query, the version of OpenEdge that you are querying, and the actual query being used.
The version of OpenEdge is 11.7. I'm using WinSQL within an automated script which calls this simple SQL query:
SELECT pub.ser_mstr.ser_serial_id + ',' + pub.ser_mstr.ser_part + ',' + ltrim(rtrim(pub.ser_mstr.ser_lotser))
FROM pub.ser_mstr
JOIN pub.pt_mstr ON pub.pt_mstr.pt_part = pub.ser_mstr.ser_part and
pub.pt_mstr.pt_domain = pub.ser_mstr.ser_domain
WHERE (pub.ser_mstr.ser_site = '1US-PDC2' or
pub.ser_mstr.ser_site = 'DUS-PDC2' or
pub.ser_mstr.ser_site = 'ZUS-PDC2') and
pub.pt_mstr.pt_part_type = 'FG' and
pub.pt_mstr.pt_group = 'BOVEDA' and
left(pub.ser_mstr.ser_serial_id,1) <> 'Z' and
(left(pub.ser_mstr.ser_part,1) = 'B' or
left(pub.ser_mstr.ser_part,2) = 'MB') and
pub.ser_mstr.ser_commission_date = (curdate() - 1)
Order by pub.ser_mstr.ser_serial_id asc
Thanks in advance for any help you can provide.