Gosh, I hope you really mean "SQLRPGLE" (SQL embedded into ILE RPG)
instead of "SQLRPG" (RPG III)
The key thing to understand is that you're asking to learn two different
1) The SQL language.
2) How to embed SQL statements in an RPG program.
The big thing is learning SQL. This is the same whether it's in RPG,
Cobol, the command-line, ODBC, JDBC, QM Query, etc.
The second item ("how to embed") is actually relatively simple. There's
just one directive ('exec sql') that's added to the RPG language, plus a
few new variable types, and a bunch of predefined variables. That's it.
IBM's SQL programming manual (as well as the reference manual) are in
the Information Center. There's also a manual on how to embed it into a
If you find the IBM books hard to follow, you might try "SQL/400
Developer's Guide" by Paul Conte and Mike Cravitz.
On 4/17/2012 11:43 AM, arthur perkins wrote:
Are there any good books on SQLRPG or documentation that is available
for those who want to learn it?