Re: Returning a result set from an RPG stored procedure

Yes, you can use QTEMP files. We use them all the time, as well as
multi-occur DS..



David L. Mosley, Jr.
Technical Solutions Architect | 919.379.3730
Dancik International | www.dancik.com
www.facebook.com/dancikinternational



David Gibbs <david@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/08/2012 03:16 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Returning a result set from an RPG stored procedure






Folks:

Can someone clarify something for me ...

As I understand it, in order to return a result set from a stored
procedure written in RPG, you have to return a multi-occurrence data
structure OR another result set.

In the case of a result set, is it possible to return a result set from a
query on a file in QTEMP?

Thanks!

david