Re: V4R5 Query Select or Omit error..

Just upgraded a customer from V4R3 to V4R5. (yes I KNOW they are WAY behind but they are regulated etc.etc.etc.) We loaded Every Cume and Group. All is well except:

A BUNCH of Queries that ran fine in V4R3 fail with CPD4019, "Select or omit error..." The error goes on to tell us that a field used to construct a result field contains an invalid value. True statement. However that same record has always existed (migrated data from DEC system) and has always contained an invalid value. However that particular record should be (and always has been) omitted by the select criteria higher in the list than the ones using the result field that can't be built for this record.

As this is several versions back (and my mind is foggy back that far), was there a change to Query to evaluate all result fields before doing select/omit? Is there a way around this? I've scoured QAQQINI and found nothing I also see nothing in the archives. I have every PTF that references anything about this error.

Our only work around is to build an intermediate file and work from that, however these folks have hundreds of queries with the same problem!

Thanks!!

- Larry

--
Larry Bolhuis           | IBM eServer Certified Systems Expert
Vice President          |     iSeries Technical Solutions V5R2, V5R1, V4R5...
Arbor Solutions, Inc.   |     iSeries LPAR Technical Solutions V5R2
(616) 451-2500          |     e-business for AS/400 V4R2
(616) 451-2571 -fax     | IBM eServer Certified Systems Specialist
lbolhuis@xxxxxxxxxx     |     iSeries System Administrator for OS/400 V5R2
www.arbsol.com          |     RPG IV Developer
                        |     iSeries System Command Operations V5R2
                        |     Client Access

---
[This E-mail scanned for viruses by Declude Virus]