Re: UDF return *PGM parm?

Hi Justin,

there is another solution to tackle that problem - but this involves creating a small snippet of C code to call your RPG program.

You don't have to create a whole C program - only a small part which does the program call. This small part is then simply included into the SQL sourced function between declaring a variable for the return value and returning that variable from the SQL function.

This way, the SQL "compiler" will generate C source code for a small *SRVPGM which is the backend for the SQL sourced UDF. And when SQL passes that C source code to the ILE-C compiler to compile it, the small C-snippet will be included.

We have to do it that way, because SQL has not idea of doing a native call to a *PGM object - but ILE-C can do that of course.

It sounds harder than it is - I will try to create a small example later and send the sources to the list if you like.

Regards,
Daniel

Am 22.01.2026 um 20:39 schrieb Justin Taylor <jtaylor.0ab@xxxxxxxxx>:
That tracks. The *PGM "should" be a *SRVPGM, but anyway...

Thanks




On Thu, Jan 22, 2026 at 12:17 PM Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>
wrote:

You need two SQL modules ( if you will make it the clean way) :

1) Create a stored procedure that wraps the RPG *PGM - your can use the
basic parameter style. That is basically just a parameter template for SQL
to know how it calls your program - no real object is created here.

2) Create a scalar function that calls the procedure and and returns the
output parameter from the stored procedure.

We do it all the time, so we can "call an RPG program" within a select from
statement.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.