Plug into the power of RPG with SQL

For a two minute overview of this training click play.

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.

Here's is what you will learn:

Work with host variables to pass data from RPG to SQL statements Unsure of the syntax of an SQL statement? Develop and test SQL statements in the Interactive SQL environment, copy/paste the working statements into RPG Work with data returned from SQL SELECT statements in your RPG programs using cursors Cursors: read-only and updateable, serial, scroll and dynamic: know when and how to use each Boost SQL performance with DECLARE and PREPARE SELECT statement options to get just the data you want: LIKE, IN, BETWEEN, NOT and multiple conditions Work with column functions for statistics, summing and counting See how using GROUP BY gives you "level break" type functionality in SQL Develop and test RPG code with joins: inner join, outer joins, exception join and cross join The power of one: how to combine SQL statements into one statement, using subselects, correlated subqueries, nested tables and joins Simplify SQL error handling in your code with the WHENEVER statement Use the SQL Communication Area to get all information about an SQL error or warning

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. SQL for RPG Programmers includes over a dozen RPG coding labs where you'll develop, test and debug RPG code using embedded SQL. This is gold!