Now that you can tell SPs from UDFs, let’s find out how to create RPG-infused stored procedures, step by step.
By Rafael Victória-Pereira
In the previous TechTip, I (very briefly) introduced Persistent Storage Modules and explained the differences between stored procedures (SPs), user-defined functions (UDFs), and triggers. Now let’s go deeper into the creation process of SPs. How do you build them? The answer is kind of funny—you already have! Almost any existing program or procedure can be made available as an SP, you just need to register it in SQL as such. This includes, naturally, yourRPG programs and procedures.