RE: Returning Resultsets from RPG Subprocedures

DS & RTNPARM are what I do too.


-----Original Message-----
From: Jon Paris [mailto:jon.paris@xxxxxxxxxxxxxx]
Sent: Thursday, January 30, 2020 12:23 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Returning Resultsets from RPG Subprocedures

If returning as a DS then make sure to use RTNPARM or your performance will suck.

Any approach other than a DS will create additional processing overhead at both ends of the call so I would only do it if the bulk of the usage was as a called procedure or something. If it is RPG calling RPG it is a no brainer.

On Jan 30, 2020, at 1:02 PM, Richard Schoen <richard@xxxxxxxxxxxxxxxxx> wrote:

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>

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com