Reader Feedback and Insights: Printing Leading Zeros in Query/400, Another Look

June 12, 2002 Timothy Prickett Morgan

Hey, Ted:

In response to your “Odds and Ends” article in the May 31 Midrange Guru, OS/400 Edition, specifically the tip that discusses Printing Leading Zeros in Query/400, Another Look, there’s another way to ‘skin a cat.’

Use an edit word with an extra zero at the beginning of the field. For example, to edit a Social Security number, I use edit word 0nnn-nn-nnnn. It works just fine unless you need to print this field starting at print position 1.

— Rich

Sponsored By ADVANCED SYSTEMS CONCEPTS

SEQUEL meets all your iSeries and AS/400 data access needs in a single, integrated solution: Windows, Web or host user interfaces Convert AS/400 data into PC file formats E-mail or FTP query results, reports and spool files Run-time prompted queries and reports for end users IF-THEN-ELSE logic in queries and reports Report, form and label formatting second to none Easily convert date fields, character-to-numeric, numeric-to-character and other data manipulation SORT or JOIN using a calculated field Quick summarization of data with Tabling function Run multiple SEQUEL requests as one with the SEQUEL Scripting function OLAP Business Intelligence at a fraction of the cost of comparable solutions Take 6 minutes to view a SEQUEL ViewPoint ScreenCam movie to see how simple Windows-based AS/400 and iSeries data access can be! In just a few short minutes, you can find out ways to make your job easier and improve data access throughout your organization. Download the ViewPoint movie here . For more information or a FREE trial of SEQUEL, call 847/605-1311 or visit Advanced Systems Concepts .