Re: Noob SQL Help

Hello,

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 things:

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 program.
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzahg/rzahgsql.htm

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:

Hi all,

Are there any good books on SQLRPG or documentation that is available
for those who want to learn it?


Thanks,

Arthur