As a registered member of Search400.com, you're entitled to a complimentary copy of Chapter 2 of SQL for eServer i5 and iSeries written by Kevin Forsythe and published by MC Press. " SQL in iSeries Navigator" explains how to use the SQL scripting tool included in iSeries Navigator, such as how to configure the SQL script environment and run multiple SQL scripts.
In this book, you will learn about Structured Query Language (SQL), but with an IBM eServer i5/iSeries twist. The future seems clear on this point: SQL is the direction of the future for IBM's Universal Database. While it is true that the majority of existing databases on the i5 and iSeries were created with DDS, it's still undeniable that DDS will slowly fade from use, much like the RPG program cycle.
With a practical "how-to" style, SQL for eServer i5 and iSeries first introduces you to the basics essential for any developer to build a solid foundation. Then the book examines--in detail--the many ways in which SQL functions on the iSeries. All possible environments are explored: the traditional 5250 green-screen applications, the SQL scripting tool within iSeries Navigator, and the methods to access iSeries databases from within Visual Basic.
Learn through real-life examples of using SQL to interact with DB2 databases. You'll learn the ins and outs of sub-selects, joins, unions, and views, as well as tips and techniques for interacting with legacy applications, and so much more. Though intended for programmers already familiar with SQL, beginners will appreciate the book's handy tutorial Appendix to get started with SQL basics.
>> Want to learn more about SQL for the iSeries? Buy the book from MC Press.