Midrange Guru

I would like to sort on a field in Query/400, but I do not want to print the field on the report. I know this sort of thing is possible--I have seen it done in the past--but I can't remember how. Do you know?

Yes, this is not difficult. Select the field in the Select and Sequence Fields panel, even though you don't want to print it. This will include the field in the Select Sort Fields panel. To prevent the field from printing, go to the Select Report Column Formatting panel and set the field's length to zero.

This technique really comes in handy when you want to sort on part of a field--for example, the second and third characters of an inventory item number--since you would not normally want to print pieces of fields.

Sponsored By

CLIENT SERVER DEVELOPMENT

LEARN SQL BY EXAMPLE!

Reader Feedback: A great book! Interestingly, it could have two completely different audiences. One is the audience of traditional AS/400 people like myself, that need to learn how SQL works. And the other is the experienced SQL person, who needs to know how SQL on the AS/400 is different.
-- Jerry K.

Buy your copy of iSeries and AS/400 SQL at Work direct from the author, Howard F. Arner, Jr. This is THE book to teach you SQL on the iSeries.

The book is chock full of information that is useful for beginners and experts alike. The book comes with a CD that has all of the sample data and queries used in the book and a FREE copy of SQLThing so you can work through the examples in the book. You learn by doing!

With Howard's expert guidance, you'll learn and understand many topics, including the following:

Relational Concepts and Terms
SQL Select Basics
Manipulating Data with SQL
Advanced Select Statements for Powerful Reports
Cursors, Transactions, Journals, and Logging
Debugging SQL Statements and Enhancing Performance
Stored Procedures/Using Legacy Programs in SQL
Embedded SQL in RPG

Howard F. Arner, Jr., is a programmer who has published extensively on AS/400 integration and database topics. In his book, iSeries and AS/400 SQL at Work, Howard provides detailed coverage of SQL for business environments by using practical examples--available on the CD--to be performed by the reader. More advanced chapters teach how to become proficient in industry-standard SQL to manipulate AS/400 data, use scalar functions to summarize data, and integration of SQL into RPG and COBOL. This is the perfect guide for beginners and advanced SQL users.

Here's what readers are saying about iSeries and AS/400 SQL at Work by Howard F. Arner:

Anyone working with AS/400 query should look into buying this book. Now using AS/400 query seems a little odd and very cumbersome. His writing is laid out very well and is easy to read. While reading this, I felt that he was actually there explaining the chapters to me as a one-on-one instructor.
-- Jonathan Tripp, Deerfield Beach, Florida

If you wondered how to call AS/400 programs from your Visual Basic program correctly, this book is your one source for how to do so. It's the first book on the market that answered all of my client/server questions when I deal with PC to AS/400 programming tasks.
Not only does Howard do a good job of explaining how stored procedures work, but he gives some great coding examples on how to get you up and running correctly. Howard goes the extra mile and talks about performance, too--one thing that normally is lacking in many other books.
-- Bob Butcher, Sidney, New York

Learn how SQL can make your job easier and you more productive.
Order your copy at SQLThing.com today!