In this video, I'd like to show you an example of how you can use CREATE FUNCTION and CREATE PROCEDURE, to call RPG procedures and functions that are inside a service program.
Please, let me know what you think about it. Leave your comments below.
Don't forget to subscribe!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #sqltraining #as400 #common #modernize #sql #sqltraining #sqlrpgle #ibmchampion
0:00 Introduction
1:01 Showing the service program that Im going to use in the example
3:15 Creating a SQL procedure using CREATE PROCEDURE
5:31 Creating a SQL function using CREATE FUNCTION
6:56 Checking if they work using the Run SQL Scripts Utility
9:14 Using SQL procedures and functions from a RPG program. An example.
10:20 Testing how the program works on the green screen.
11:16 Final comments and ending