Re: Best Practice for Returning Multiple Rows from RPG to PHP

[Glenn Hopwood <ghopwood.list@xxxxxxxxx>]

We've recently come across the same issue when trying to get some 
complex data into Webquery. We solved it by creating an RPG stored 
procedure that creates a temporary table in QTEMP and then returns a 
result set over that table.

Below are the steps we took...
- create a table that contains the data points we want to return to 
Webquery/PHP.
- create the programs required to create and populate the table in QTEMP.
- After the table is created, open a cursor over it and end the program 
with the cursor still open. (Make sure the cursor is defined as 'with 
return to client' and we also have a statement that reads 'set result 
sets cursor <name of cursor>')
- create the stored procedure over your RPG program.

Glenn

On 11/30/2010 9:52 AM, Michael Ryan wrote:
> Ok...here's what I really want to know.
>
> What is the best option for returning multiple rows of data from RPG to PHP?
> Here's some of my considerations:
>
> * I don't want to do complex processing in my PHP script; I'd rather use the
> PHP to access and display data;
> * The RPG program is needed because I'll be accessing multiple tables and
> could be doing some complex processing;
> * I need to return 1-n rows of data.
> * I'm on V5R4.
>
> When I look at a stored procedure, I see that I can return a result set.
> However, I think I need to have an array or a multiple occurrence DS, which
> makes me think I would need to know how many rows I would return. I was
> thinking about a UDTF. Would that mean my RPG program would write (INSERT)
> records to the UDTF and then my PHP script would just do a simple SELECT?
> Does a global temporary table play in this?
>
> I appreciate the insight. Thanks!