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.