Re: CPF5035 on a QRY/400

Hi

I'm confused. If I understand you rightly, you are running RTVQMQRY - that should not product any output - it does put something into a source member, as the help text describes -

The Retrieve Query Management Query (RTVQMQRY) command allows you to retrieve Structured Query Language (SQL) source from a query management query (QMQRY) object.  The source records are placed into an editable source file member.

You can also retrieve query source from a query definition (QRYDFN) object when the specified QMQRY does not exist.

This command will also put messages into the joblog to explain what happened - I think I referred to this in an earlier post, so you could see if any of the things that won't convert, if they occurred.

Now STRQMQRY does let you say to use a QRYDFN - I don't know if I'd call that "retrieving" the query, but OK.

But it seems this is a different issue - I see responses today that address that.

Good luck!
Vern

On 11/27/2024 4:40 PM, a4g atl wrote:

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.