Re: PHP - Call Procedure from Service Program

Michael,

I'm instructing all programmers here to use SQL stored procedures and User
Defined Functions to call programs from the iSeries. Let us know if you
need up creating a SQL procedure / function that calls an RPGLE service
program.


On Thu, Dec 27, 2012 at 2:25 PM, Alan Seiden <alan@xxxxxxxxxxxxxx> wrote:

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!

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.