Re: "call qcmdexc parm('CLRPFM ABC' 10.00000)" in an SQL script?

[Dan <dan27649@xxxxxxxxx>]

On 10/23/06, Alexei Pytel <pytel@xxxxxxxxxx> wrote:
> What I usually do is to create external stored procedure for the program I
> need to call.
> This allows me to specify parameter types and then SQL CALL statement can
> correctly pass parameters.
>
> For example, this is stored procedure for QCMDEXC:
>         create procedure qgpl/cmdcall
>            ( in cmd    char(4096),
>              in cmdlen dec(15,5) )
>            language CL parameter style general
>            not deterministic no sql not fenced
>            program type main
>            external name QSYS/QCMDEXC


Wow, a lotta stuff in there to do something seemingly so simple!

When I ran this from RUNSQLSTM, I got SQL7909 "Routine SP_QCMDEXC was
created, but cannot be saved and restored."  (I used sp_qCmdExc instead of
cmdcall.)  What gives with that?  Is it because of "-- The external program
schema is QSYS."? (from the message help)

Where are stored procedures "stored"?  WRKOBJ on SP_QCMDEXC doesn't show
anything.  How does one delete a stored procedure?

In any case, I got it to work.

Thanks!
Dan