RE: EXTERNAL: SQL Procedure Result Sets Array Processing

On Wed, 30 Apr 2025 14:41:17 Vern Hamberg wrote:

"...creating SQL stored procedures that returns a result set(s) to an RPG-ILE array..." wasn't clear to me.

Maybe I'm making it too complicated, though! :)

Or, I'm making it too complicated! I'm a complete neophite with stored procs & UDTF's, so I apologize for probably misusing terminology. Let me start over by detailing the problem I'm trying to solve. To wit:

1) I'm re-factoring an RPG III program to ILE-RPG.
2) The user is prompted to enter a value in 1 of 3 input fields; the value is used to fetch 1 or multiple records from a PF.
3) The rub here is that each of the input fields represents a key field; therefore the program had to manage DB retrieval
using CHAIN & SETLL/READE opcodes in conjunction with three LF's built over the PF. It's ugly.
4) I wish to externalize as much of the DB access as possible, by having the SQL code fetch the (multi-column) rows (for
read only) and return them in as few program statements as possible.

I hope this better describes what I'm trying to accomplish. BTW, as a practical matter I'd wish that the solution is flexible enough to be called from other environments (i.e. Python, PHP, .NET, etc).

HTH...

--Buzz