Re: PHP Result Set/Stored Procedure

And I guess that led to my confusion/choice. I thought the i5
functions were specific or tuned to i5, while the DB2 functions are
for any DB2 implementation. Guess the implementation isn't as complete
for the two function groups.

Thanks...

On Wed, Jul 2, 2008 at 12:05 AM, Scott Klement <web400@xxxxxxxxxxxxxxxx> wrote:

Yep, that's what I use -- the db2 functions. Works great.


Michael Ryan wrote:

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.

--
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.