Coding in RPG (IBM i/AS400). Converting file operations in RPG to embedded SQL operations in RPG.

In this example video I'm converting file operations that we are used to make in RPG, to be used in SQL, so we will have embedded SQL code into our RPG code.
Have fun!

#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #sql #embeddedsql

0:00 Introduction
1:22 The initial RPG example program without SQL functions
2:19 Creating a new RPG program where I'm using embedded SQL functions
2:29 Disabling commit control in my SQL RPG program
3:23 Converting a "chain" instruction into an embedded SQL select
5:27 Converting two "chain" instructions into an embedded SQL join between two tables
8:23 Converting a "counting the number of elements readed" into an embedded SQL operation
9:38 Converting a "write" into an embedded SQL insert
10:54 Converting a "read" (inside a loop) into an embedded SQL cursor and fetch (inside a loop)
13:19 Converting a "read" (inside a loop) intro an embedded SQL cursor and fetch (only with one fetch)
16:30 Ending

[AmitSingh-lgbz]

Very nice and well explained.. Waiting for your next video.