Re: SQL Procedure Result Sets Array Processing

Hi Buzz,

you can find some info in the Info Center:

https://www.ibm.com/docs/en/i/7.5.0?topic=procedures-returning-result-sets-from-stored

But from a modern view of SQL I wouldn't recommend using a stored procedure returning a result set.

IMHO a user defined table function is the better and more modern "attack vector" as you can use the UDTF anywhere in any SQL query, where a table is usable.

https://www.ibm.com/docs/en/i/7.5.0?topic=code-example-weather-table-function

https://www.itjungle.com/2016/06/14/fhg061416-story03/

For external (RPG) UDTF Scott has created some very nice docs:

https://www.scottklement.com/udtf/

HTH and kind regards,
Daniel

Am 30.04.2025 um 17:05 schrieb Buzz Fenner via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

I've gotten the go-ahead to do a POC for creating SQL stored procedures that returns a result set(s) to an RPG-ILE array. My searches for articles and code haven't turned up any "complete" articles (although I've hit on snippets from Jon, Birgitta, etc.).

Anyone know of any good end-to-end articles that I can read to get up to speed?

--Buzz
--