Re: CL interface with Query Management to use Query/400 (RANGE)

[Peter_Vidal@xxxxxxxx]

Thank you guys!

PETER VIDAL
PALL Aeropower Corp. / SR Programmer Analyst
Website: www.pall.com  / Email: Peter_Vidal@Pall.com
Phone: 727-539-8448, x2414




                    Vernon Hamberg
                    <vhamberg@attbi.com        To:     midrange-l@midrange.com
                    >                          cc:
                    Sent by:                   Subject:     Re: CL interface 
with Query
                    midrange-l-admin@mi        Management to use Query/400 
(RANGE)
                    drange.com


                    08/21/2002 01:11 AM
                    Please respond to
                    midrange-l






Peter

First, you need to put variables in place of the constants - 102 becomes
:SHIP_YEAR  (remember the colon) - I assume you've done that.

Then your CL variables need to be *CHAR

At 02:14 PM 8/20/02 -0400, you wrote:
>Hi list!
>
>I know how to send parms to the query from the STRQMQRY command, but I have a
>problem with RANGE (I guess).  My query record selection is like this:
>
>        DYAA4C            EQ     102
>AND    DYAA4D            RANGE  10 12
>AND    DYAA39            GE     1020731
>
>Is this correct?
>STRQMQRY   QMQRY(PABQ02) OUTPUT(*OUTFILE) +
>OUTFILE(QTEMP/PABQ02) ALWQRYDFN(*ONLY) +
>SETVAR((SHIP_YEAR &SHIP_YEAR) +
>      (SFMONTH &SFMONTH) +
>      (STMONTH &STMONTH) +
>      (PRM_DATE &PRM_DATE))
>
>This is not working.  If I put the parameters directly on the query, it pulls
>the data correctly.
>What is wrong?
>
>Thanks in advance.
>
>PETER VIDAL

_______________________________________________
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.