SQL/400 Developer's Guide
||Author: Paul Conte, Mike Cravitz|
List Price: $75.00
Our Price: Click to see the latest and low price
Publisher: 29th Street Press (September, 2000)
Sales Rank: 37,902
Average Customer Rating: 4.73 out of 5
Customer ReviewsRating: 4 out of 5
Used it the day I got it
I had a vendor in the day this came to work. He asked me if I had a good SQL book and I replied, "Let's find out" and opened the box. It was perfect for what we needed. I have used it several times and it is easy to read. Being new at SQL on the 400, I am a little frustrated with the index. I was trying to figure out how to substring and couldn't find a reference anywhere. Twice I have had to forego the book and ask another person.
It is a great learning tool and I'm very glad I bought it.
Rating: 5 out of 5
SQL for the 400/iSeries Cool!
SQL the standard for data access is now presented in a AS400/iSeries user format. The differences that exist for the DB2/400 user are minor but significant enough to warrant 500 pages plus.
Conte and Cravitz flood the text with real working examples that hit homeruns with the IBM midrange user. Yet, minus the sprinkling of RPG/ILE & Cobol code any DB2 user would find the text extremely helpful.
Keep this book at the ready since it's a "quick grab" when questions come up regarding triggers, UDF's or Database Modeling and design.
The Book is a great starting point for the AS400/iSeries guru looking to open their database to the outside world. With a solid SQL footing the JDBC mountain is a much easier climb.
Conte & Cravitz keep up the great work!
Rating: 5 out of 5
Salvation for a Windows Developer
As a VB developer, I have experience with Informix, SQL Server and Oracle. But implementing SQL on the AS400 was a challenge. This book was my salvation. It provided the necessary information to help my team develop secure ODBC access to the AS400 using SQL Stored Procedures.
We were able to create tables that provide different record format and file names, and short field names for RPG non-SQL access, as well as long (meaningful) names for Visual Basic / SQL access. We learned how to evaluate SQL naming vs. System naming. And we learned how to provide secure ODBC connections by revoking some of the "public" authorities and using SQL stored procedures with program adopted authority.
Phase II of the project will be WEB based. It's nice to know our DB2 implementation and SQL stored procedures will work whether we use Java, VB .NET or a mixed development environment.
I took my copy of the "SQL 400/Developer's Guide" to the office. People kept "borrowing" it, so I had the company buy a copy. It quickly became the most popular book in the company library. It was in such demand that several developers bought their own copies.
I hope this book is updated annually to incorporate new DB2/400 features. I would gladly purchase future revised editions covering topics like "Implementing Datalinks", "How to find the AS400 job log for ODBC requests", "Using SQL Statements to Define Database Triggers", "Retrieving Disconnected Recordsets" with JAVA and VB examples, "Creating Pivot Tables", "Populating Grids", "Multiple System Joins" (if IBM ever offers this common SQL feature), and more SQL examples.
· ILE by Example
· The Modern RPG IV Language, 3rd Edition
· Subfiles in RPG IV : Rules, Examples, Techniques, and Other Cool Stuff
· Database Design and Programming for DB2/400
· iSeries and AS/400 SQL at Work