RE: CPF5035 on a QRY/400

You have to check the joined files for invalid numeric values ... one after the other!

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g atl
Sent: Wednesday, 27 November 2024 23:41
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: CPF5035 on a QRY/400

I did run the retrieve SQL but it did not produce any output, basically no records found.

There is an OR condition. I commented out the first part of the OR and it ran showing me a bunch of null columns but gave data. I then switched to the condition after the OR and it too produced output. When they ran together, they produce no output. Makes no sense as the only difference is the first condition selects warehouse 002 and the second part of the OR is warehouse 007. The rest of the where conditions are identical.

There were no messages when I ran it.

Thanks, Darryl.

On Wed, Nov 27, 2024 at 4:59 PM Vern Hamberg via MIDRANGE-L < midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Bryan

How is RSS going to run a Query for i query? And if Darryl isn't
getting a QMQRY that really works, it won't help, methinks, to run it
in RSS - he could run the QMQRY and see various SQL* messages that
might give him a clue.

Cheers
Vern

On 11/27/2024 10:48 AM, Bryan Dietz wrote:

use Run SQL Scripts instead of green screen

Bryan

a4g atl wrote on 11/27/2024 10:38 AM:

I have inherited a QRY that was created before 2020. It has been
running daily ever since until this weekend.
The QRY is a complex QRY with 18 files.

Does anyone know of a way to get a dump of the values in the fields
of the QRYDFN when it fails? DMPJOB does not work.

I tried converting to a QMQRY to get the SQL. The SQL produces no
errors but returns an empty list of records. I see some records
when working in WRKQRY and use F5 to display the report and it does
give me records. The column in error has ++++.

I need to see the contents of the fields at the time to locate the
problem.

TIA, Darryl Freinkel.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.