SQL/400 Developer's Guide (Vol 2) (Paperback)

by Mike Cravitz (Author) "This book teaches you how to use Structured Query Language, or SQL, which is a computer language used to define and manipulate databases..." (more)
Key Phrases: commitment control environment, common table expressions, source file member, Create Table, Create View, Alter Table (more...)

Editorial Reviews

Review
A comprehensive, indispensable resource for students, programmers, and database administrators who need to learn about the AS/400 database. -- Bernadette Cinkoske, Assistant Professor, Ivy Tech State College

A practical database design and SQL programming textbook specifically for AS/400 application developers. -- Frank G. Soltis, IBM AS/400 Chief Scientist and Prof. Computer Engineering, Univ. of Minnesota

Both newcomers to the AS/400 and experienced AS/400 programmers will find SQL/400 Developer's Guide an excellent resource. -- Sharon L. Hoffman, Senior Analyst, TechReflections

This book is where you should start learning SQL on the AS/400. -- Kent Milligan, DB2 & BI Solutions, AS/400 Partner World for Developers

Product Description
Paul Conte and Mike Cravitz have written the must-have guide to SQL for AS/400 application developers. SQL/400 Developer's Guide is an authoritative book that will help you create and manipulate comprehensive, complex, professional-quality SQL/400 databases. The textbook covers database and SQL fundamentals, SQL/400 Data Definition Language (DDL) and Data Manipulation Language (DML), and database modeling and design. Coding suggestions reinforce the topics covered and provide practical advice on how to produce robust, well-functioning code.

See all Editorial Reviews

Product Details

• Paperback: 508 pages
• Publisher: 29th Street Press; Subsequent edition (September 2000)
• Language: English
• ISBN-10: 1882419707
• ISBN-13: 978-1882419708
• Product Dimensions: 10 x 8.4 x 1.1 inches
• Shipping Weight: 2.7 pounds
• Average Customer Review: 4.8 out of 5 stars See all reviews (19 customer reviews)
• Amazon.com Sales Rank: #383,442 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #15 in

  Books > Computers & Internet > Hardware > Mainframes & Minicomputers

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

5.0 out of 5 stars Best book to learn SQL/400, February 1, 2001

By	Terry W. Smith "[e-mail]" (Aumsville, Oregon United States) - See all my reviews

If I were teaching (or taking) a class on SQL/400, or just wanting to learn how to develop AS/400 database applications, this is _the_ book that I would want to use. The information needed to develop AS/400 SQL applications is available from other sources, but contained in hundreds of technical manuals, magazine articles, news group postings, and code examples (just to name a few sources). The authors have used their considerable knowledge and experiences to shorten the learning process for the reader by pulling together that information into a single place. I am especially impressed with the organization of material into manageable topics, the easy to read writing style, and numerous tips and techniques presented. I found reading this book more like reading a good novel and wanting to see what happens in the next chapter rather than reading a textbook. I have to admit however I live with this stuff every day. Having been an AS/400 database administrator for the past 10 years I can appreciate the amount of knowledge, experience and effort required to write a book of this kind. The only downside to this book that I found is that I would have liked to see more information about developing applications using JDBC, interfacing with Windows applications using ADO and ODBC, and serving AS/400 information via Web pages. I find an increasing part of my workload to be answering questions about these topics. A good majority of those questions however don't deal with language specific access mechanisms but rather from a lack of understanding about AS/400 specific features and database fundamentals, topics which are well covered in this book. After reading this book I do have one additional problem also. Now I need to buy a stack of these books to hand out to the numerous developers who cross my desk on a daily basis.

8 of 8 people found the following review helpful:

5.0 out of 5 stars SQL for the 400/iSeries Cool!, May 9, 2001

By	R Stearns (Oregon City, OR USA) - See all my reviews

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!

11 of 12 people found the following review helpful:

5.0 out of 5 stars Salvation for a Windows Developer, April 15, 2001

By	"jarvine1" (Chesterfield, MI United States) - See all my reviews

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.