Let's explore the nuts and bolts of using embedded SQL: file type, syntax, and compiling.
In a previous article, "Why Use Embedded SQL Within RPG?", I talked about why you would use embedded SQL in RPG. In this article, I will talk about how you could use embedded SQL within RPG. We'll start with an existing RPG program that is written with CHAIN and READ, and then we'll convert it to use embedded SQL.