Re: PHP Result Set/Stored Procedure

Hi Scott -

I've been trying to use the i5* functions. I raised the issue with the
national sales guy and the new i5 guy, and they both agreed that it
doesn't work...but it should. I was told that the issue was being
raised with the Zend development team, but I haven't heard of a
resolution. Perhaps my solution is to use the DB2 functions and not
the i5 functions.

On Tue, Jul 1, 2008 at 12:43 PM, Scott Klement <web400@xxxxxxxxxxxxxxxx> wrote:

Hi Michael,

I've done quite a bit of calling RPG code as stored procedures from PHP,
and haven't had any problems. You say "Zend can't/won't either"? What
does that mean, exactly? You paid them to consult on your project, and
they told you that PHP can't call stored procedures? I can't believe that.

The IBM_DB2 module of PHP certainly states that it supports stored
procedures, and I use them without problems. What am I missing?


Michael Ryan wrote:

I've been trying to return a result set from a stored procedure into a
PHP script. My idea behind this was to enable both display file
programs and PHP programs to access the same business logic. I would
take an existing program, break out the business logic into a stored
procedure that returns a result set, and then access that stored
procedure from either an RPG program or a PHP script. However, I can't
get this to work, and Zend can't/won't either.

So here's my question: Is this a bad idea? What's a better approach? I
want to be able to produce 'something' that could be accessed by
either a display file program or a PHP script. I know I could create a
file as an intermediate step, but that seems so kludgy. Ideas?
Comments? Catcalls?

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.