|
I agree that RTVQMQRY is not the ultimate tool to learn SQL.
But things have changed as to what that command generates.
There used to be a problem that ALL join types were retrieved with WHERE clauses, as you say, and as type 1 JOIN types.
There were PTFs to change that - there are probably supercedes for these -
V5R4 - SI42309
6.1 - SI42345
7.1 - SI42363
At 7.1 I just created a type 2 JOIN *QRYDFN with 3 files. I then ran RTVQMQRY over it.
The SELECT statement used 2 LEFT OUTER JOINs - exactly what I would expect.
For a type 2 JOIN *QRYDFN, things are a little more interesting - they also implement it with 2 LEFT OUTER JOINs, with tests in the WHERE clause for IS NULL on columns in the 2nd and 3rd dial.
That could have been done with EXCEPTION JOINs, I guess - but at least the JOINs are written out as true SQL JOINs.
HTH
Vern
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
