RE: update query with case statement

Tom and Matt have the answer.  Thanks a lot.  

I made the substitution variable in the qmqry and the setvar variable name
have the same case and it worked like a charm.  I've been doing simple
qmqrys with substitution variables in batch for several years, and I've
never managed to do this before.  If you stagger around in the dark long
enough, you eventually bump into something. <g>

> -----Original Message-----
> From: qsrvbas@netscape.net [mailto:qsrvbas@netscape.net]
> Sent: Thursday, February 13, 2003 4:27 PM
> To: midrange-l@midrange.com
> Subject: RE: update query with case statement
> 
> 
> Joel:
> 
> At first glance, it looks like you have a substitution 
> variable named "&file" but you're passing a value in for 
> "&FILE". Note the difference in case. QM query substitution 
> variable names are case-sensitive.
> 
> If so, either change your update statement or put quotes 
> around the name of the variable in the STRQMQRY SETVAR() 
> parameter to force lower-case.
> 
> Tom Liotta
> 
> midrange-l-request@midrange.com wrote:
> 
> >with a message that says: " Message . . . . :   Global 
> variable prompting is
> >not allowed in batch mode.  Cause . . . . . :   You tried to use the
> >variable
> >   "file                          " before it was set.  Prompting for
> >variables
> >   cannot be done in batch mode. "  It goes on to advise 
> using the setvar
> >parm, which I did in the CL.  The strqmqry statement was:
> >
> >  DCL        VAR(&UPDFILE) TYPE(*CHAR) LEN(20) +
> >               VALUE('LIBRARY/FILENAME')
> >  STRQMQRY   QMQRY(QRYNAME) SETVAR((FILE +
> >               &UPDFILE))
> 
> -- 
> -- 
> Tom Liotta
> The PowerTech Group, Inc.
> 19426 68th Avenue South
> Kent, WA 98032
> Phone  253-872-7788 x313
> Fax    253-872-7904
> http://www.powertechgroup.com
> 
> 
> __________________________________________________________________
> The NEW Netscape 7.0 browser is now available. Upgrade now! 
> http://channels.netscape.com/ns/browsers/download.jsp 
> 
> Get your own FREE, personal Netscape Mail account today at 
> http://webmail.netscape.com/
> _______________________________________________
> 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/mailman/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.
>