What tool (STRSQL, ACS - Run SQL Statement)are you using when executing the
SQL Statement?
When running it through ACS make sure you are on the latest version 1.1.8.6
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Richard Schoen
Sent: Samstag, 23. Januar 2021 19:05
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: 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
--
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
