Power RPG with SQL

With Power RPG with SQL you'll quickly modernize your RPG skills. Instead of relying solely on limited RPG file operations, you'll add the power and convenience of SQL to your RPG programming. SQL is a powerful, convenient and universal tool and, if you program with RPG, there's no better way to learn SQL than to actually see how it is used in RPG programs.

Using the SQL pre-compiler, you'll embed SQL statements in your RPG code. With SQL you'll put more "ease of use" and functionality into your RPG programs. You'll work with data returned by SELECT statements and use INSERT, UPDATE and DELETE statements to make changes. You'll learn how to create new files quickly and easily in an RPG program, without needing to call system commands.

Developed by programmers for programmers, this hands-on SQL training shows you plenty of short-cuts, gives you tips and real-world advice on how to develop and test statements. Most importantly, you'll learn by running actual code on your system. Power RPG with SQL includes over a dozen RPG coding labs where you'll develop, test and debug RPG code using embedded SQL. This is gold!

Media: Self-paced manual with source code CD. Estimated completion time: 20 hours.