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

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
--