RE: QM/400 Conversion

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Dennis Munro wrote:

-snip about converting from QRY/400 to QMQRY-

>The major dilema now is what to do with those queries 
>(6) that create a file?  

STRQMQRY OUTPUT(*OUTFILE) should help.

>What I would like to know is what options I have 
>because these 6 queries have variables that 
>change (from/thru dates, accounting period, etc.) 
>with each running?  

QMQRY allows you to use variables.
SELECT FLD,FLD,FLD from FILE where FLD = &TEST

STRQMQRY xxx SETVAR(TEST &CLVARNAME)

>I have a question related to QM/400 & what people 
>do to "emulate" Query/400 Option 2 of matching 
>records - i.e., always take the primary file record
>even though there is no match on the secondary file.  
>I only have 1 of these to deal with but how do I deal 
>with QM/400 not having that capability?

Depending on what you need, look at LEFT OUTER JOIN or UNION.  UNION is
pretty easy:
SELECT F1.FLD,F1.FLD,F2.FLD from FILE1 F1,FILE2 F2 where F1.KEY = F2.KEY
union
SELECT FLD,FLD,'Not Found; from FILE1 where KEY not in 
  (SELECT KEY from FILE2)
ORDER BY 3,2,1

Buck Calabro
Aptis; Albany, NY


Billing Concepts Corp., a NASDAQ Listed Company, Symbol: BILL
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---