AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage

IBMi and AS400 Training
HOME >> Training Catalog >> SQL for RPG Programmers

SQL for RPG Programmers (RSQL)
Author: Daniel Jacobs
$695 ON SALE NOW $595 - YOU SAVE $100

Plug into the power
of RPG with SQL

With SQL for RPG Programmers 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.

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!

SQL for RPG Programmers (RSQL)
Author: Daniel Jacobs
$695 ON SALE NOW $595 - YOU SAVE $100

Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2