|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.