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

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