Re: Create table as and RUNSQLSTMS

That was my first thought...but nope...

https://www.rpgpgm.com/2019/08/executing-cl-commands-using-runsqlstm.html

Charles

On Mon, Aug 26, 2024 at 12:13 PM Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

I believe the CL: works only in Run Sql Scripts.

You will need to use QSYS2.QCMDEXC. Here's an example from an SQL
procedure:

declare Cmd varchar(1024);

set Cmd ='DSPPGMREF PGM('
concat trim(p_INLIB)
concat '/' concat trim(p_INPGM) concat ')'
concat ' OBJTYPE(' concat p_INTYPE CONCAT ')'
concat ' OUTPUT(*OUTFILE)'
concat ' OUTFILE(' concat WrkFileOS concat ')'
;
CALL QSYS2.QCMDEXC (Cmd);

Complete procedure here:

https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/blob/master/PGM_REFS/pgm_refs.sql

Sam

On 8/26/2024 1:30 PM, Gad Miron wrote:

Now how do excecute CL CMDs in this SQL source :
the CL: prefix throws an error .

Gad

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

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