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

[Alexei Pytel <pytel@xxxxxxxxxx>]

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


    Alexei
Disclaimer: this message represents only my personal opinion.

 "We have every reason to assume that our assumptions are not without 
reason". 




Dan <dan27649@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/23/2006 11:00 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

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






I am attempting to clear several files at the top of an SQL script that
later populates those files.  (I would prefer to not use SQL's DELETE to
"clear" the file.)

I know that SQL supports calling programs with no parameters.  In a crude
test, I was able to prove that it is possible to pass parameters, as long 
as
they are specified in hexidecimal format, i.e., CALL ABC (x'C1').  Is 
there
a way to do this without mucking up the SQL script?  The SQL Reference and
Programming Guide don't offer much, although the programming guide gave an
obscure example of calling a program from a C program.

TIA,
Dan