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 <[email protected]> on behalf of Justin Taylor <[email protected]>
Sent: Tuesday, March 3, 2026 12:35 PM
To: RPG programming on IBM i <[email protected]>
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 <[email protected]> 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: [email protected]
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: [email protected]
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 [email protected] for any subscription related questions.

-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.