Re: SQL UDF to call RPG without service program

Use ACS to pull the SQL that creates the table and use that.  

You find it in the same place as where you created it. 


Jim Oberholtzer
Agile Technology Architects

> On Mar 3, 2026, at 1:12 PM, Eric Wesson <[email protected]> wrote:
> 
> 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.
> 
-- 
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.