RE: QM Question

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

Dennis wondered:
>I have a CL program that has a DSPF that prompts for 5 variables & a QM/400
>query.  What has me struggling now is how do I pass in a variable from the
>display file that contains *ALL to the query.  One thought was to do a
>BETWEEN.  When *ALL is entered on the prompt screen, I substitute "  " &
>"99" & when I have anything else, it goes on both sides of the BETWEEN.
>Seems clean & easy enough to understand.
>
>I'm wondering if someone else has a better way to do the *ALL & individual
>value being passed in to a QM/400 query running in a CL program or will
*ALL
>work & I don't know how to make it work?

Several ideas to ponder:
1) Use several QMQRY definitions; 1 for no WHERE clause, 1  for a single
element, etc.  Cheap and easy, but not exactly elegant
2) Have an HLL program create the entire SQL statement and have a single
QMQRY definition.  More complex, but all the changes happen in one place
(the HLL pgm)
3) Go with embedded SQL if possible (preserves the query template for reuse)
4) HLL constructs an OPNQRYF statement (well, it's something to consider...)

Buck Calabro
Commsoft; Albany, NY   
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.midrange.com


+---
| 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
+---