Re: remote execution on System i

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.