iSeries and AS/400 SQL at Work [Paperback]

Howard F. Arner Jr. (Author)

Book Description

Publication Date: March 28, 2001

This is THE book to teach you SQL on the iSeries and AS/400 platform. Howard will take you from the beginning to the end with information for beginners and experts alike. Best of all, the book comes with a CD that has all of the sample data and queries used in the book, plus a FREE copy of SQLThing that you can use to work through the examples in the book so you learn by doing. You will learn and understand how to:

Create SQL statements

How SQL is implemented on the AS/400

Tune for performance

Deal with legacy issues

Take advantage of new features available only in SQL

Write complex aggregate queries

Write stored procedures

Editorial Reviews

From the Author

In late 1999 I started consulting with shops that had legacy systems on the AS/400. From this work, I gained insight into the techniques record level access programmers used when laying out physical and logical files on the AS/400 and how to make SQL perform against these types of tables. I have worked with numerous packages on the AS/400, adding EIS and OLAP systems built using SQL or doing complex reporting using Crystal Reports, and I tried to bring that experience to the book. So, this is not just a book detailing how to create a table in SQL, as most of you already have tables currently on your AS/400. This book tells you how to deal with those tables and create SQL statements that will rock the house with their performance and scalability. It also deals with some of the issues that are unique to using SQL in a legacy environment.

I know the AS/400 database inside and out, from an SQL perspective, and I can teach it to you that way. I relate the concepts in terms you already know, and teach you the grammar of relational databases. SQL is the future of the AS/400 platform, and I think I have a book that can not only teach you SQL, but can also teach you the advanced queries, performance tuning and database concepts you need to enhance your job performance and your career.

About the Author

Howard F. Arner, Jr. is vice president of Client Server Development, a consulting and development firm in Jacksonville, Florida. He has over 18 years of experience in the computer industry and has worn many hats: tape ape, programmer, systems architect, systems analyst, database designer, systems implementer, data minor, expert system creator, writer and consultant. He has published over 40 articles in the trade press on integration of AS/400 legacy systems to client/server and Web-based systems.

Product Details

• Paperback: 336 pages
• Publisher: Mc Pr Llc (March 28, 2001)
• Language: English
• ISBN-10: 1583470247
• ISBN-13: 978-1583470244
• Product Dimensions: 7.2 x 6 x 0.9 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #2,535,912 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars Best reference for SQL, October 2, 2003

By 

Mark Goodfellow (Mount Holly, NJ United States) - See all my reviews

This review is from: iSeries and AS/400 SQL at Work (Paperback)

This book is the perfect book for you if you are writing SQL on the AS/400 or using a ODBC/JDBC to submit SQL to the AS/400. It contains all the little-used gems that make your job easier. In addition, it shows both the common and uncommon uses of SQL in clear, practical examples you can easily repeat.
It's organized so that a programmer under the gun can easily find what they need and get on with the project. In my opinion, it is "THE" essential reference for SQL on the AS/400.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Great learning tool !, December 20, 2001

By 

Jonathan Tripp (Deerfield Beach, FL USA) - See all my reviews

This review is from: iSeries and AS/400 SQL at Work (Paperback)

Anyone working with AS400 query should look into buying this book. Not only does Howard explain how SQL works, he also gives working examples with the sample data included on the CD. Now using AS400 query seems a little odd and very cumbersome.

His writing is laid out very well and easy to read. While reading this, I felt that he was actually there explaining the chapters to me as a one on one instructor.

Great Job!

2 of 2 people found the following review helpful:

5.0 out of 5 stars Best for PC/400 software developers, June 19, 2001

By 

Bob Butcher - See all my reviews

This review is from: iSeries and AS/400 SQL at Work (Paperback)

If you wondered how to call AS400 programs from your Visual Basic program correctly, this book is your one source for how to do it.

First book on the market that answered all of my client/server questions when I deal with PC to AS400 programming tasks!

Not only does Howard do a good job of explaining how stored procedures work, but gives some great coding examples on how to get you up and running correctly. He goes the extra mile and talks about performance too, one thing that normally is lacking in many others out there.

Nice job Howard. Look forward to others in the future!