Re: remote execution on System i

[CRPence <CRPbottle@xxxxxxxxx>]

  SQL has a CALL statement to invoke a /stored procedure/.  Look at the 
CREATE PROCEDURE (External) statement of SQL.  If the parameters are 
well defined with standard SQL data types [i.e. not data structures], 
then the create procedure request can define the VRU program directly by 
name as the EXTERNAL NAME to be called with the specified parameter 
declarations.  The parameters that are both input to the program and 
output from the program would be declared using the INOUT specification.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstcreatep.htm
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstcrtpef.htm

  FWiW:

  To run a CL command, the SQL CALL can invoke a command processing API 
such as QCMDEXC.  For example the following request to change the job in 
which the SQL is running, to use default inquiry message reply handling:

    CALL QSYS.QCMDEXC ('CHGJOB JOB(*) INQMSGRPY(*DFT)', 0000000029.00000)

  For ease of use, in some SQL scripting the above CALL can be replaced 
by CL: as prefix to a request, directing the script processor to send 
the request to a command request processor instead of treating the text 
as a SQL statement; e.g. CL: CHGJOB JOB(*) INQMSGRPY(*DFT)

Regards, Chuck

smorrison@xxxxxxxxxxxxxxxxxxx wrote:
> Can anyone point me to how to execute a remote command on the System
> i, from an ODBC connection?  We want to allow our VRU (Voice Response
> Unit) to execute a specific program on the System i. The program
> needs to send and receive several character parameters.
>
> I've seen stuff on executing remote commands on another System i, and
> from the System i to a PC, but what do I need to do to implement this
> over an ODBC connection?
>
> The connecting system is running Windows 2003, and the program is
> IPCC Express Version 5.0(2) SR1, connecting over ODBC.