Re: PHP Result Set/Stored Procedure

[Scott Klement <web400@xxxxxxxxxxxxxxxx>]

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!