RE: Query/400 converted to SQL

Michael, the search function on your blog site does not appear to be working. I searched for WRKQRY and got "No Results". (I did find the WRKQRY to SQL tip via your second link.)

- Dan Bale

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Michael Mayer via MIDRANGE-L
Sent: Wednesday, July 16, 2025 12:34 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Michael Mayer <michael.mayer@xxxxxxxxxxxxx>
Subject: RE: Query/400 converted to SQL

EXTERNAL: This email originated from outside of the organization. Do not click on any links or open any attachments unless you trust the sender and know the content is safe.

I have an SQL that I can send along that will convert any QRY or QMQRY to SQL in a source member file.

It can be found on my IBM i Reference Pages Blog <snip>

*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***