<div>
<i>I can't seem to find anything that works.</i><br />
<br />
What goes wrong? Is there an error message?<br />
<br />
What platform is PHP running on? What i5/OS version is running?<br />
<br />
Can you show us a sample of your PHP coding?<br />
<br />
Tom<br />

</div>


I can't seem to find anything that works.

What goes wrong? Is there an error message?

What platform is PHP running on? What i5/OS version is running?

Can you show us a sample of your PHP coding?

Tom


<div>
iSeries is V5R4<br />
PHP 5.3.1<br />
<br />
I'm really at the point of trying to figure out how to construct the command in php. &nbsp;I've found examples like:<br />
$result=runStoredProc(&quot;exe<wbr />c GETSTORES(1550)&quot;); &nbsp;<br />
<br />
where GETSTORES(#) is the name of my stored procedure. &nbsp;<br />
<br />
runStoredProc is not recognized.<br />
<br />
I'm just not sure how to do it...
</div>


iSeries is V5R4
PHP 5.3.1

I'm really at the point of trying to figure out how to construct the command in php.  I've found examples like:
$result=runStoredProc("exec GETSTORES(1550)");  

where GETSTORES(#) is the name of my stored procedure.  

runStoredProc is not recognized.

I'm just not sure how to do it...

<div>
<div class="content wysiwyg-content">
I have a stored procedure GETSTORES(#####) which requires a five digit account number and returns all stores for that account. &nbsp;I need to call that stored procedure from php using an ODBC connection. &nbsp;I can connect to the 400 and query directly but want to use the stored procedure to cut down on traffic.<br />
<br />
I can't seem to find anything that works.
</div>
</div>


I have a stored procedure GETSTORES(#####) which requires a five digit account number and returns all stores for that account.  I need to call that stored procedure from php using an ODBC connection.  I can connect to the 400 and query directly but want to use the stored procedure to cut down on traffic.

I can't seem to find anything that works.

Calling AS400 Stored Procedure from PHP with ODBC

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.