SQL for eServer i5 and iSeries

Rating:
Summary: Must have book for the innovative programmer
Review: Any programmer can copy and modify code to make a workable program. The real programmer creates code to meet the needs of the project. In order to stand out in todays world, it is absolutely essential that every available tool be brought to bear in order to hone the skills of the programmer. This book is written to help every level of programmer to use SQL in order to take full advantage of todays Systems and todays and tomorrows data needs. Kevin writes in an easy to read and understand style so even the novice programmer can find it useful. He also provides plenty of technical information to expand the edge of the programmer who already knows everything and doesn't usually use references. This book is a must have for the programmer working in this environment.

Rating:
Summary: Covers the i5/iSeries Dialects of SQL
Review: This book has two aspects. Basically it's on the SQL programming language (Yes, Martha, it's a language).

On the one hand it is aimed at the IBM i5/iSeries developers the tools they need to effectively use SQL in their applications.

On the other hand it is equally aimed at the experienced SQL programmer that is now moving to the i5/iSeries who needs to know the particular twists and kinks in the implementation as well as the tools available on the system to support development.

It's clear the future of data base interaction lies in SQL. It's also clear that without a book on the specific dialect of SQL spoken by the particular version you are running you can't write effective code. The structure of each data base engine is just a bit different. I don't believe that any of them meet the full standard.

This is a novice to Intermediate level book. It starts with the simple SELECT statement and goes through JOINS, UNIONS, Sub-Selects, enough that the user can probably do what he wants. The book spends a good bit of time on converting from the older DDS/RPG based software.

This book is an excellent start. It's hand's on enough to make sense, detailed enough to get you through the first through months of work before you're ready to tie into the details of advanced SQL -- Let alone the always coming next version.

Rating:
Summary: A "Must Have" book for iSeries programmers
Review: This is a great book on the topic of SQL within the realm of IBM midrange platforms. It covers not only the obvious topics (interactive SQL, basic SELECTs etc.) but goes in depth on the topics of QM Manager, SQL within iSeries Navigator and interfacing SQL with MS Office. It is big on the practical aspects of SQL and is easy to read and understand.

Rating:
Summary: Sql for eServer i5 and iSeries
Review: We are new to SQL and have found this book to be invaluable. Especially when added to some other books we have. Kevin has gone out of his way to answer questions and help. This is a must have book for any iSeries Shop that is using SQL and Embedded SQL.