Re: PHP Result Set/Stored Procedure

["Alfredo Delgado" <adelgado@xxxxxxxxxxxxxxxxx>]

What's the nature of the difficulties you've run into? Do you have any code
to share? (http://code.midrange.com)

I've used stored procedures with PHP on IBM i before Zendcore and it took
some extra steps back then. I haven't done it in a while but we can probably
help if you can provide more details.

I documented how I called an RPG program as an external stored procedure
back in 2006:
http://www.i5php.net/index.php?name=Forums&file=viewtopic&p=775#775

On Tue, Jul 1, 2008 at 8:55 AM, Michael Ryan <michaelrtr@xxxxxxxxx> 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.