Re: PHP - Call Procedure from Service Program

Michael,

If you plan to use PHP with IBM i then here is how to do it using the new toolkit:
http://www.alanseiden.com/2012/12/27/service-program-procedures-with-php-toolkit-for-ibm-i/

Here is the key line:

/* Call service program procedure.
* In this example, assume your program is MYLIB/MYPGM and has a procedure/function 'myproc'
* (procedure name is case-sensitive).
* Note: specify optional procedure name in parameter 5, an array with associative index 'func'.
*/
$result = $conn->PgmCall('MYPGM', 'MYLIB', $params, $retParam, array('func'=>'myproc'));


There is no practical limit to the number of parameters that can be passed.

Alan

Michael Ryan <mailto:michaelrtr@xxxxxxxxx>
December 27, 2012 12:43 PM
Looking for direction here. I've been casting around, but haven't found the
answer (or don't know that I've found it). I can call a procedure from a
service program from PHP, right? Is there a limit to the number of parms
that can be passed?

Is a stored procedure a better way to go? I'm thinking that it may be,
especially since a stored procedure can be called by different interfaces
(PHP, ODBC, etc.). Does this make sense?

Thanks!