Re: sql to output row as csv string

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/19/2018
04:40:15 PM:

you can call an external rpg from the sql stored procedure, that can

then

execute the cl command... but wayyyy too much engineering for what I'm
trying to accomplish...
but thx for the ideas.

It is easy to call a CL command or CL program from an SQL MAIN
stored procedure. IBM provides a stored procedure definition for the
QCMDEXC program. So, you can use it like this:

Declare Str1 VarChar(5000);
Declare StrLen Decimal(15,5);

Set Str1 = 'CALL UTSETLLCL (''' || CompNumb || ''' *FIRST)';
Set StrLen = Length(Str1);
Call QCMDEXC (Str1, StrLen);


Sincerely,

Dave Clark