Re: Passing in a date into STRQMQRY

That did it!  Thank you.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





Pete Hall <pbhall@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/25/2003 12:05 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Re: Passing in a date into STRQMQRY


At 10:42 8/25/2003, Rob Berendt wrote:
>Trying to run STRQMQRY from the command line and not a CL.
>The QMQRY looks like:
>...
>   WHERE     DTDATE >= DATE(&PROMPTDATE)
>...
>where DTDATE is a date field.
>
>If I do a STRQMQRY QMQRY(ROUTINES/SYSDOWNQM1)
>and just type in '2003-05-01' when prompted it works.
>However if I try
>STRQMQRY QMQRY(ROUTINES/SYSDOWNQM1) SETVAR((PROMPTDATE '2003-05-01'))
>it pulls in all dates.

I remember QMQRY being very picky about quoting alpha data (which I think 
a 
date would be in this case). Try inserting literal quotes in the parameter 

value:
STRQMQRY QMQRY(ROUTINES/SYSDOWNQM1) SETVAR((PROMPTDATE '''2003-05-01'''))

Pete Hall
pbhall@xxxxxxxxxxxxx
http://www.pbhall.us/

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.