Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

iSeries / AS400 FAQ : Programming : RPG : How do I write an SQL UDF in RPG?

April 26, 2017AS400 iSeries Programming rpg sql UDF write

0

Posted

iSeries / AS400 FAQ : Programming : RPG : How do I write an SQL UDF in RPG?

1 Answer

0

Posted

Here’s a very simple example of an SQL UDF (user defined function) in RPG IV. The RPG is compiled as a *PGM, not a *SRVPGM. I owe David Morris thanks for pointing me to the April 2000 article in Midrange Computing.