Regular marked price: $64.95Discount Price: $58.45
Cost Savings: $6.50 (10%)Price fluctuation possible.
How soon does it ship: Usually ships in 6 to 8 days
Shipping? Absolutely FREE if you qualify for Super Saver Shipping.
Type of bind: Paperback
Dewey Decimal Number: 005
EAN num: 9781583470480
ISBN number: 1583470484
Label: Mc Press
Manufacturer: Mc Press
Quantity: 1
Page Count: 350
Printing Date: September 01, 2004
Publishing house: Mc Press
Sale Popularity Level: 270118
Studio: Mc Press
Other books you might be interested in perusing:
Editor's Notes and Comments:
Product Description:
This examination of how SQL functions on the iSeries considers at all possible environments, including the traditional 5250 purple screen applications, the SQL scripting tool within iSeries Navigator, and Visual Basic. Database management from creation to deletion is covered in detail. Programmers will learn how to implement referential constraints and primary and unique key indexes, check constraints, and journal physical files. How to extend a database with user-defined functions and procedures and how the new GUI development tools provide simplified methods for running, debugging, and tuning SQL statements are also explained.
User popularity level:
Rated by buyers 
-
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.
Rated by buyers -
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.
Rated by buyers -
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 very first through months of work before you're ready to tie into the details of advanced SQL -- Let alone the always coming subsequent version.
Rated by buyers -
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.
Find other books like this one:
