This examination of how SQL functions on the iSeries considers at all possible environments, including the traditional 5250 green 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.
FREE Two-Day Shipping for students on millions of items. Learn more |
Book Description
Frequently Bought Together
Editorial Reviews
About the Author
Kevin Forsythe has over 19 years of experience on the iSeries and other platforms as programmer, analyst, consultant, and instructor. He blends a wide range of experiences with a passion for teaching and is the author of numerous articles. Kevin has developed AS/Credentials Courses for Interactive SQL and Embedded SQL. He is a frequent and award-winning speaker at COMMON conferences and other iSeries user conferences.
Product Details
Would you like to update product info or give feedback on images?
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
7 of 7 people found the following review helpful:
5.0 out of 5 stars
Covers the i5/iSeries Dialects of SQL,
By
This review is from: SQL for eServer i5 and iSeries (Paperback)
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.
5 of 5 people found the following review helpful:
4.0 out of 5 stars
Sql for eServer i5 and iSeries,
By Bill Barnes "Bill" (NC, USA) - See all my reviews
This review is from: SQL for eServer i5 and iSeries (Paperback)
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.
5 of 5 people found the following review helpful:
5.0 out of 5 stars
Must have book for the innovative programmer,
By
This review is from: SQL for eServer i5 and iSeries (Paperback)
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.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
SQL is a common database language available on most if not all major computing platforms. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
binder script, temporary table object, using parameter markers, express rentals, binary radix tree, inventory transaction file, sales history file, transaction history file, customer master file, record format name, select substr, sql close, parameter style, scripting tool, national machine, select statement, logical file, commitment control, job log, record lock Key Phrases - Capitalized Phrases (CAPs): (learn more)
Visual Explain, Item Master File, Cancel Help Figure, Set Cmd, National Machine, Meijer Marina, Triad Express Rentals, Back Next, Cancel Figure, Repeatable Read, Coded Character Set Identifier, Private Sub, Con Cmd, Connection Dim Cmd As New, Erie Ave, Operations Navigator, Close Set Con, Dim Con As New, Set Dat, Display Data Data, Query Optimizer Timed Out-Indicates, Read Committed, Visual Basic, Cancel Apply Help, Central Ave New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
SQL is a common database language available on most if not all major computing platforms. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
binder script, temporary table object, using parameter markers, express rentals, binary radix tree, inventory transaction file, sales history file, transaction history file, customer master file, record format name, select substr, sql close, parameter style, scripting tool, national machine, select statement, logical file, commitment control, job log, record lock Key Phrases - Capitalized Phrases (CAPs): (learn more)
Visual Explain, Item Master File, Cancel Help Figure, Set Cmd, National Machine, Meijer Marina, Triad Express Rentals, Back Next, Cancel Figure, Repeatable Read, Coded Character Set Identifier, Private Sub, Con Cmd, Connection Dim Cmd As New, Erie Ave, Operations Navigator, Close Set Con, Dim Con As New, Set Dat, Display Data Data, Query Optimizer Timed Out-Indicates, Read Committed, Visual Basic, Cancel Apply Help, Central Ave New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Citations (learn more)
Books on Related Topics
(learn more)
|
|
What Other Items Do Customers Buy After Viewing This Item?
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product).
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
