Re: Noob SQL Help

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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