RE: QUERY TO SQL

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

There's an ANZQRY command that's supposed to give some hints of what may or
may not work IMPORT properly to Query Management.

At 09:55 AM 3/19/02 -0500, you wrote:
>So one thing we've figured out here is that RTVQMQRY does not always convert
>cleanly/accurately?  Mike, were there any warning messages on the output
>that suggested that there might be problems?
>
>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 Smith, Mike
>Sent: Tuesday, March 19, 2002 9:42 AM
>To: 'midrange-l@midrange.com'
>Subject: RE: QUERY TO SQL
>
>
>that did it.
>
>thanks
>
>
>-----Original Message-----
>From: Fisher, Don [mailto:Dfisher@roomstoreeast.com]
>Sent: Tuesday, March 19, 2002 9:24 AM
>To: 'midrange-l@midrange.com'
>Subject: RE: QUERY TO SQL
>
>
>I may be way off base here, but I think the problem is the WHERE clause on
>the fields in the second file.  If there is no associated record found in
>the second file the selection criteria fails because the fields in the
>second file are null instead of blank, "AC", or "PN".
>
>How about something like:
>SELECT UMACT, UMPRM, UMSTS, UOACT, UOARA
>FROM uact left outer join
>      uactov
>   on umact = uoact
>where (Uoara = '' or Uoara is null) and
>       (umsts in('AC', 'PN') or umsts is null)
>
>I may be wrong on the syntax, of course.
>
>Donald R. Fisher, III
>Project Manager
>The Roomstore Furniture Company
>(804) 784-7600 ext. 2124
>DFisher@roomstoreeast.com
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.