Re: PHP Result Set/Stored Procedure

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

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.