Coding in RPG (IBM i/AS400). Using a SCROLL CURSOR.
In this video, I'd like to show you an example of how to reuse a CURSOR between two different executions.
For that, I can use a SCROLL CURSOR.
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 #as400 #common #modernize #sql #sqlrpgle #ibmchampion
0:00 Introduction
0:55 Showing and explaining the RPG program where I am using a SQL cursor.
2:05 Showing the compilation options to check when the cursors are automatically closed.
3:06 Compiling and checking the program execution (the program opens and closes the cursor every time it runs).
4:43 Changing the program so I will keep the cursor open while the activation group is open.
5:10 Compiling and checking the program execution (the program doesn't close the cursor between executions). Problems!
7:00 Solving the problem using a SCROLL CURSOR.
8:30 Compiling and checking the program execution (the program reuses the cursor every time it runs).
10:53 Using a named activation group.
11:59 Closing the activation group (and the cursors).
12:18 Final comments and ending