Get started Bring yourself up to speed with our introductory content.

SQL for eServer i5 and iSeries -- Chapter 2

Learn how to use the SQL scripting tool included in iSeries Navigator.

As a registered member of, 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.

SQL for eServer i5 and iSeries

Book description:
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.

>> READ "Chapter 2 -- SQL in iSeries Navigator" now.

>> Want to learn more about SQL for the iSeries? Buy the book from MC Press.

Dig Deeper on iSeries SQL commands and statements

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.