Re: PHP Result Set/Stored Procedure

["Alfredo Delgado" <adelgado@xxxxxxxxxxxxxxxxx>]

You're welcome, but keep in mind that I was using PHP4 in PASE, not Zend
Core. Wanting to consume SQL result sets from RPG and PHP via store
procedures is sound practice so you have better functionality at your
disposal with the official release.

I've been meaning to contact Zend for Zend Platform. The mileage on "I'm too
busy to upgrade" is starting to run out :)

On Tue, Jul 1, 2008 at 9:35 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

> Hi Alfredo -
>
> Thanks for the response. I've been attempting to use i5_Prepare and
> i5_Execute, while I see you used an ODBC call. Let me study your
> solution a bit and I'll get back to you.
>
> - Michael
>
> On Tue, Jul 1, 2008 at 9:19 AM, Alfredo Delgado
> <adelgado@xxxxxxxxxxxxxxxxx> wrote:
> > 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.
> >
> >
> > --
> > Alfredo Delgado / Web Development
> > 6800 Broken Sound Pkwy; Suite 150
> > Boca Raton, Florida 33487
> > T: (561) 443-9152
> > C: (561) 350-4143
> > F: (561) 443-9108
> > --
> > 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.
> --
> 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.