Re: PHP Result Set/Stored Procedure

["Aaron Bartell" <aaronbartell@xxxxxxxxx>]

Does PHP have a concept of how RPG does arrays? (obviously PHP has extensive
arrays, I just don't know how well they relate to RPG's arrays).

If they relate well, then I would consider using arrays to pass result sets
back and forth because that would allow both RPG and PHP to easily use the
same style of result set (even though it isn't really based on SQL at that
point).  The catch is that obviously RPG's arrays are limited in size.  I
don't view this as a significant problem because we should be developing our
applications to do paging in the first place vs. passing back thousands of
records at a time.  Instead you could pass parms into your RPG business
logic to state how many records you want returned and at which record to
start at.

HTH,
Aaron Bartell
http://mowyourlawn.com

On Tue, Jul 1, 2008 at 7: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.