Re: Query/400 converted to SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi again

I think I forgot to say, the info for this is in Chapter 12 of the 
*Query Management Programming* manual.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.660Y9QaD.sk5PkXFP@centurylink.net> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023

On 7/16/2025 9:21 AM, Vern Hamberg via MIDRANGE-L wrote:
> 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