Guild Companies, Inc.  
 
Midrange Stuff - Hardware, Software & Services
OS/400 Edition
Volume 2, Number 3 - January 16, 2002
In This Issue
You Have Questions. The Gurus at Guild Companies Have Answers.
Sponsored By
JACADA LTD.

Gartner Research on
Legacy Extension & Jacada

See why Jacada is the leading legacy extension solution according to Gartner. This 30 page report includes approaches to legacy extension, vendor rankings in the Magic Quadrant, and case studies. It's a must-read for anyone planning legacy extension projects.

Get your FREE copy at www.jacada.com/gartner/quadrant32.

Sponsored By
WORKSRIGHT SOFTWARE, INC.

Indiana and Arkansas have new area codes! How are you going to update your customer files?

We have the answer. Our ZIP/CITY System for the AS/400 can automatically update your customer files for this area code split and future ones as well.

Visit our Web site www.worksright.com to learn more about ZIP/CITY. We offer a free, no-hassle, 30-day trial. Phone, fax, e-mail us, or order your free trial directly from our Web site.

Retrieve Subtotals and Detail Data at the Same Time

Hey, David:

I have an RPG report that uses embedded SQL to select records from an order file. The report shows total sales for products within a sales region. I need to add columns that show the total percent of total sales for each product within a sales region and for each region within the report. I could read the records twice and calculate the percentage of the totals using values stored on the first pass. But is there a way to avoid reading these records twice?
--Priscilla

READ MORE >

Somebody's Got My Report!

Hey, Ted:

Some of our users were inadvertently walking off with other people’s reports, so I put the user profile name in the print text of some of our programs.

This solutions works fine; it solves the problem. But I've been asked to improve it. Is there a way to put the user's name in the print text instead? And some of the user IDs are cryptic; is there a way to include some routing instructions?
-- Blake

READ MORE >

Reader Feedback and Insights
We value your feedback and your insights into the OS/400 market. Feel free to drop us a letter to the editor and we will post them in a reader feedback column associated with this newsletter. READ MORE >
Subscription Information To unsubscribe, change your email address, or sign up for any of Guild Companies's free e-newsletters, visit www.itjungle.com/sub/subscribe.html
This page is best viewed at 800x600 with Netscape or IE browsers 4 or higher.
 
THIS ISSUE
SPONSORED BY:
Jacada Ltd.
WorksRight Software, Inc.
BACK ISSUES
TABLE OF CONTENTS
Retrieve Subtotals and Detail Data at the Same Time
Somebody's Got My Report!
Reader Feedback and Insights

Editors
Ted Holt
Howard Arner

Managing Editor
Mari Barrett

Technical Editor:
David Morris


Contact the Editors
Do you have a gripe, inside dope or an opinion?
Email the editors: editors@itjungle.com

  Newsletters | Subscribe | Advertise | About Us | Contact | Search | Home  
  Last Updated: 1/16/02
Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.