Re: Dumb question about STRQMQRY passing parms

[CRPence <CRPbottle@xxxxxxxxx>]

  I did not see this posted yet on the correct group\list, so I will 
respond here.

  I do not think this is a problem with quoting; the logged CL request 
from the CLP should /look just like/ what was specified on a command 
line for a successful invocation.  In this case, the QMQRY source was 
compiled referencing &fromdate, *however* the SETVAR() is passing a 
literal assignment for the variable &FROMDATE.  Recreate the QMQRY from 
source which has changed to use\name the variable name &FROMDATE instead 
of &fromdate, and try the CLP again.

http://www.google.com/search?hl=en&q=qmqry+upper+case+variable+name+v5r4
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/books/sc415703.pdf

Regards, Chuck

Rowe, Sheri wrote:
> I have converted a QUERY/400 query to QM, so that I can pass 2 parms
> to it.  The QM is fine and I can run it on-line successfully, it
> prompts for the fields I want and I enter them successfully.   My
> problem is I am trying to run it in batch, so that is can be run
> through our job scheduler, and it fails.  I have fiddled with
> changing the parms to be numeric but it still didn't work.  After a
> day and ½ of testing I am exasperated, as I know the solution must be
> very simple.
>
> Here is my CL
>
> <<SNIP>>
>
> STRQMQRY   QMQRY(ZROYIRON) QMFORM(ZROYIRON) +
> DATETIME(*NO) PAGNBR(*NO) ALWQRYDFN(*yes) +
> SETVAR((FROMDATE &QRYFROM) (TODATE &QRYTO))
>
> <<SNIP>>
>
> Here is my submit statement:
>
> SBMJOB CMD(CALL PGM(RUNZROYIRN) PARM('080101' '081231'))
>
>
> Here is the error log I get.
>
> Message . . . . :  -CALL PGM(RUNZROYIRN) PARM('080101' '081231') 
> 01/09/09  12:36:04.266408  QCADRV       QSYS        03AE
> RUNZROYIRN  SROWE
>
> Message . . . . :     2700 - STRQMQRY QMQRY(ZROYIRON)
> QMFORM(ZROYIRON) DATETIME(*NO) PAGNBR(*NO) ALWQRYDFN(*YES)
> SETVAR((FROMDATE '''080101''') (TODATE '''081231'''))
>
> 20   01/09/09  12:36:04.369792  QQXSRV01     QSYS        *STMT
> QQXSRV01 From module . . . . . . . . :   QQXCPIMESS From procedure  .
> . . . . . :   QQxCPIMessage__SendMessage Statement . . . . . . . . .
> :   16 To module . . . . . . . . . :   QQXCPISTRI To procedure  . . .
> . . . . :   QQxCPIString__ResolveSingleVar Statement . . . . . . . .
> . :   37 Message . . . . :   Global variable prompting is not allowed
> in batch mode. Cause . . . . . :   You tried to use the variable 
> "fromdate                      " before it was set.  Prompting for
> variables cannot be done in batch mode. Recovery  . . . :   If you
> are using the STRQMQRY command you can set variable "fromdate
> " by using the SETVAR keyword. <<SNIP>>