Coding in RPG (IBM i/AS400). Using CREATE FUNCTION and CREATE PROCEDURE

Опубликовано: 27 Октябрь 2024
на канале: Christian Larsen
1,105
33

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