Returning Resultsets from RPG Subprocedures

Hey RPG folks,

In thinking about using RPG subprocedures and service programs for querying individual records and record sets, what would be the best way to call a subproc that returns a resultset and have it return the data to the calling program ?

For my discussion the calling program could be another Green Screen app or a web app.

What are my options for most universal DB access code re-use ?
-Return as data structure ?
-Return as JSON or XML packet ?
-Write to temp DB table ?
-What about actually returning the results object ?

I suppose just using copy books is an option to include at the code level on-the-fly.

Insight appreciated since I don't do as much RPG as I used to.

Thanks

Regards,
Richard Schoen
Web: http://www.richardschoen.net<http://www.richardschoen.net/>
Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>