Re: Return result set with Stored procedure in V6R1

On 3/17/2016 10:47 AM, Wilson, Jonathan wrote:

Then my_stored_procedure would then do some stuff and then return X
number of records.

I have no idea if such a thing is possible. My vastly _limited_
understanding of SP's is that they are singular in nature - they only
work on a single "record" between the caller and called.

Not at all; stored procedures can return multiple rows to the caller.
For example, to return all of the sales history for a particular
customer. The SP takes the customer number as a parameter and returns
the result set with columns for product number, description, price,
quantity, etc. One row for each product the customer bought.

My .NET people use my stored procedures exactly like this. They ask for
'Give me a list of products' and I write a stored proc. This way they
don't have to learn about the gory details of how I store sales history.
And when I change the sales history database, the stored proc's RPG
code shows up in my cross reference tool. And I can make changes to the
database without having to notify them :-)