Re: Passing in a date into STRQMQRY

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

On the prompt, whatever you type is put into the SQL statement, including 
the apostrophes. In a SETVAR, it takes whatever is BETWEEN the apostrophes. 
When you use a SETVAR, you need to "quote" the apostrophes. So, use

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

See an appendix (I think) in the Query Management Programming manual for 
more info - not the Query Manager manual.

BTW, in CL with STRQMQRY, I usually have a variable

DCL &APOST *CHAR 1 ''''

and *CAT it to the start, *CAT or *TCAT to the end of what need to be 
strings in the statement.

Also, don't put apostrophes around you substitution variables - it is no 
longer handled as a variable but as real text.

HTH

Vern

At 10:42 AM 8/25/2003 -0500, you 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.
>
> Rob Berendt