×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.