RE: QUERY TO SQL

["Dan Bale" <dbale@xxxxxxxxx>]

First, the accusation is based on WRKQRY *QRYDFN objects being converted to
QM via RTVQMQRY.  The complaint I expressed is with the way RTVQMQRY
converts to SQL, not necessarily QM itself.  Buck, have you had no problems
converting queries with joins?  Vern provided an IBM reference describing
potential problems with this type of conversion.

Based on Mike Smith's experience, here's what RTVQMQRY generated (and failed
to produce the same results as the WRKQRY query):

SELECT
  ALL       (T01.UMACT), T01.UMCKD, T01.UMPRM, T01.UMPCN,
            T02.UOARA, T01.UMTYP, T01.UMSTS
  FROM      RGFILES/UACT T01,
            RGFILES/UACTOV T02
  WHERE     T01.UMACT = T02.UOACT
    AND(    UOARA = ''
    AND     UMSTS IN ('PN', 'AC'))
  ORDER BY  001 ASC

And here's what finally worked, according to Mike, courtesy of Don
Fisher(?):

SELECT UMACT, UMPRM, UMSTS, UOACT, UOARA
FROM uact left outer join
     uactov
  on umact = uoact
where Uoara = '' and
      umsts in('AC', 'PN')


Dan Bale
SAMSA, Inc.
989-790-0507
DBale@SAMSA.com <mailto:DBale@SAMSA.com>
  Quiquid latine dictum sit altum viditur.
  (Whatever is said in Latin seems profound.)


-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On Behalf Of Buck Calabro
Sent: Tuesday, March 19, 2002 11:17 AM
To: midrange-l@midrange.com
Subject: RE: QUERY TO SQL


Dan Bale wrote:

>But, we've discovered that QM does not
>handle joins very well.

That got my attention.
I use joins in QM all the time.  What failures have you seen?
  --buck