Re: Quoted text when invoking program call via QSYS2.QCMDEXC?

[Richard Schoen <richard@xxxxxxxxxxxxxxxxx>]

I tried the same on my box and it worked in *SYS or *SQL mode.

Was wondering if that could be an issue.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
----------------------------------------------------------------------

message: 1
date: Fri, 22 Jan 2021 17:49:58 -0800
from: x y <xy6581@xxxxxxxxx>
subject: Re: Quoted text when invoking program call via QSYS2.QCMDEXC?

Space after QCMDEXC.  When I copied/pasted into QCMD, that was the immediate error.

On my box, it's in QSYS.

On Fri, Jan 22, 2021 at 10:55 AM David Gibbs via MIDRANGE-L < midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> OK, I think I'm missing something obvious ... but this is driving me crazy.
>
> I'm trying to invoke a program call through the QCMDEXC SQL procedure.
>
> Since the parm is in quoted text, I assume I have to double 
> quote/escape the quotes in the parms.
>
> I am getting an error saying the String ') )' is invalid.
>
> I'm running something like this:
>
> CALL QSYS2/QCMDEXC('CALL PGM(XYZ) PARM(''ABCDEF'')')
>
> I've tried triple quoting the parm with a different error.
>
> What am I missing?
>
> Thanks!
>
> david
> --