RE: SQL UDF to call RPG without service program

With Reverse Engineering you can generate the SQL code from each database object (and save it into a source file if you want).
Go into ACS Schemas, Open your schema, position on your database object - Right click - Generate SQL - Generate DDL.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Eric Wesson
Sent: Tuesday, 3 March 2026 20:12
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL UDF to call RPG without service program

That works...
I like to have it in a source member so I can guarantee the exact function is created on all partitions.
________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Justin Taylor <jtaylor.0ab@xxxxxxxxx>
Sent: Tuesday, March 3, 2026 12:35 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL UDF to call RPG without service program

Creating the UDF should be as simple as:
1. ACS Schemas
2. Expand Schema
3. Right-click Functions => New => External 4. Fill in the wizard



On Tue, Mar 3, 2026 at 8:43 AM Eric Wesson <fjwesson@xxxxxxxxxxx> wrote:

I'll try calling RPG directly from a function.

I'm really curious how you use unit tests. Are they set to run
automatically when you push code to production? How do you get results
from the unit tests?

--
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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&data=05%7C02%7C%7C56acb464b168403b8ddb08de7953b98d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C639081597657403092%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=ycGJEw7klG7DDbYWAe4PAKEMPa3c7qexrnQdmGnCrxo%3D&reserved=0<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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&data=05%7C02%7C%7C56acb464b168403b8ddb08de7953b98d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C639081597657428599%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=vdcR2eiXu8Tf03S5Y2l0Et5Hj8NHwUgQ0eWMEgKiD0o%3D&reserved=0<https://archive.midrange.com/rpg400-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.