Bob Cozzi is the owner of Cozzi Productions, Inc., and has been involved in the IBM i platform since System/38 CPF release 1 and everything in between. His focus for decades was improvements to RPG (i.e., "The Modern RPG Language" book series), but today spends his time advocating the use of IBM DB2 SQL for IBM i to provide the kind of solutions users can start using immediately. You can reach him though his product website at http://www.SQLiQuery.com.
April 10, 2017 Bob Cozzi
Since the early 1990s, developers have been using SQL embedded in RPG as a way to retrieve just the right data for the task at hand. Certainly it was at least a decade before it became commonplace to see SQL embedded in RPG, but now, 15 years later, it is in fact the go-to method for data access, or at least you can see it from here.
I was an early adopter of SQL, but an off-again, on-again user of embedded SQL. Originally, I felt the first format RPG with quasi-free format SQL (and all those plus signs to continue …Read more