Hi Bill
First, since 7.2, the conversion will use the correct JOIN type. There
used to be a problem - PTFs fixed it, finally included on and after 7.2
üPTF IDs as of April 2011
V5R4SI42309
6.1SI42345
7.1SI42363
üFixed in i5/OS 7.2
The ANZQRY command can help you with the conversion - here are some
examples from a presentation I give on this -
ANZQRY QRY(LABQM01/LABQRY02) - will see messages in job log
Type of join ignored.(QWM2332)
Previously defaulted field selections used. (QWM2324)
Analyze completed for query LABQRY02 in LABQM01, code 30.
Messages are in this range -
DSPMSGD RANGE(QWM2301 QWM2399) DETAIL(*BASIC)
That first message used to be there for any non-type 1 query - not anymore.
The messages include info for both the query and the form.
You can also use the RTVQMQRY command - you can specify a Query/400 as
the source - create a source file, QQMQRYSRC, of length 91 - I know,
it's weird, some compliance thing with other IBM systems.
If there are issues, you'll find the same messages in the job log - do
ANZQRY first.
If you want the layout, use RTVQMFORM. That source file would be
QQMFORMSRC of length 162 - again, I know!
When you use either command, check the job log for messages, especially
for the form - there are things that don't convert so easily for the
form layout.
If you'd like the presentation, let me know, I think we see our email
addresses in these posts.
*Regards*
*Vern Hamberg*
IBM Champion 2025 <cid:part1.mzdR9tzy.0ig1mA7Y@centurylink.net> CAAC
(COMMON Americas Advisory Council) IBM Influencer 2023
On 7/16/2025 8:59 AM, Bill and Lisa Howie wrote:
Hello all,
I have a question. I'm trying to convert a Query/400 query into an SQL statement. Would I be right in thinking that option 3 for the type of join in Query/400 (Unmatched records with the primary file) would correspond to a LEFT join in SQL? I ask because I've written an SQL query that I think should correspond to the Query/400 query I'm working with and the data results aren't matching. Thanks in advance for any info.
Bill
midrange.com
