RE: QM/400 Question Further explained

[Dennis Munro <DMunro@xxxxxxxxxxxxxxxxxxxx>]

What I should further clarify is that the two variables I am working with
are Alpha & I am not sure of the dreaded quotes & how many?

I also said the variable goes on both sides of the BETWEEN & that obviously
is not correct.

Here are the actual statements from my query that I wish to substitute with
variables from a prompt screen.

<snip - Part of my QM/400 query)

AND (LWHS  BETWEEN '  '   AND '99')           
AND (LCARR  BETWEEN '      '   AND '999999'))
<snip>

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Tuesday, May 08, 2001 1:31 PM
To: Midrange List (E-mail)
Subject: QM Question

V4R5M0 with latest cum & group ptf's in house but not yet applied.

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?

Looked through the two QM/400 manuals I found & I found nothing or maybe I
didn't know what to search on?  I tried the archives a few minutes ago & I
was not able to get to the home page but I will try there later in the day.

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

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