RE: V4R5 Query Select or Omit error..

["Mark A. Manske" <mmanske@xxxxxxxxxxxxxxxxxx>]

I forget which os upgrade did this, but we had some queries that
we had to go into and save in order for them to work due to
query and data base changes internally in the os.

Since they work interactively, have you tried saving one, and
then seeing if it works in batch mode?

Mark

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Larry Bolhuis
Sent: Monday, April 14, 2003 10:04 AM
To: Midrange Systems Technical Discussion
Subject: Re: V4R5 Query Select or Omit error..


Follow-up. Said queries run correctly when run On-Line!  Huh?

Larry Bolhuis wrote:
> 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]

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.