You may try to use the QCMDEXC stored procedure and build the CL-Command
dynamically.
Something like this:
CALL QCMDEXC(' CALL PGM(YOURLIB/YOURRPGPGM) PARM(''' concat Lib.VARIABLE
concat ''') ');
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
IBM Champion since 2020
"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)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
atl
Sent: Friday, 27 October 2023 19:50
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Can one use a variable in a SQL script?
I have a script that is doing a few tasks.
I use CREATE VARIABLE and then populate the variable from a SELECT
statement.
I then need to run a CL command to call a RPG program using the VARIABLE i
created.
Can one do the following in ACS's Run SQL Scripts?
CL:CALL PROGRAM PARM(Lib.VARIABLE)
TIA, Darryl Freinkel.
--
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.
midrange.com
