Returning a Results Set from a Stored Procedure

["DebbieKelemen" <DebbieKelemen@xxxxxxxxxxx>]

I hope this is the right group to ask maybe not.  However, I will start
here.  I want to create a Stored Procedure which will be used by a windows
form application.  To present the data quicker I want to use an RPG program
underneath the covers.  How can I return a result set from an RPG program?
I am used to sending all of my fields back as individual parms.  The
programmer developing the windows form application has asked for a single
result set.  We do this with SQL all the time however the data we are going
after is in multiple files and it is single record time access which has
better performance with RPG. 

 

Can someone point me in the right direction?

 

Debbie Kelemen

Sr. Programmer / Analyst

CHEFS

719-272-2617

dkelemen@xxxxxxxxxxxxxxxx

www.chefscatalog.com