Guild Companies, Inc.  
 
Midrange Stuff - Hardware, Software & Services
OS/400 Edition
Volume 2, Number 32 - April 26, 2002
In This Issue
You Have Questions. The Gurus at Guild Companies Have Answers.
Sponsored By
WORKSRIGHT SOFTWARE

On June 30, 2002
$$$$  Postal Rates will go UP!  $$$$

On Monday, July 1, your
$$$$  postage bill can go down.  $$$$

CASS certify your mailing names and addresses and presort your outgoing mail with our CASS certification and presort software and save. WorksRight Software is the number-one source for iSeries and AS/400 CASS, presort, ZIP Code, and area code software and data. Visit www.worksright.com , call (601) 856-8337, or e-mail software@worksright.com .

Sponsored By
TRAMENCO

If you work with the AS/400 or iSeries, there's one event this year you can't afford to miss: The iSeries and AS/400 Connection Conference, June 16-19, 2002, in Naples, Florida.

Continue your training and education with some of the industry's greatest minds leading you through what's hot in RPG, Java, Websphere, SQL, systems operations. There's something for everyone -- and it's all within a beautiful five-star resort in sunny Florida.

To register, call 800-897-5923 or go to www.tramenco.com/naples

Common Table Expressions Make Summarizing Data Easy

Hey, Howard:


I want to display sales summaries by vendor for this year and the previous year in an Active Server Page. I know how to code this in a program, but I want to code it for a single result set. I tried joining the statements together, (left outer join), but sometimes there are no sales, (yet), for this year, so I do not retrieve any records for the previous year. I would really like to see a single record that contains all of the data for a vendor, both this year and last, and includes the previous year's data. Can you help?

-- Sam

READ MORE >

Windows Power Settings Might Disconnect Ops Console

Hey, Joe:

I'm using Operations Console V5R1M0 as my system console for an OS/400 V5R1 machine, and I've hit a snag. When I use the console to save my system (GO SAVE, option 21), the PC5250 terminal session for the system console (DSP01) will suddenly disconnect in the middle of the save. I then have to end the PC5250 session and restart it again by right-clicking on my OS/400 connection in Operations Console (Ops Console) and selecting the Console option from the pop-up menu. Of course, this causes problems during my backup.

-- Daniel

READ MORE >

Reader Feedback and Insights: Book Recommendation

Several years ago, I sold a system that ran on the old RISC PC under AIX. [The writer is referencing the article, "Qshell vs. DOS," from the April 19 issue of Midrange Guru, OS400 Edition.] About a week before that system was to be installed, my company experienced a personnel problem with its only Unix-trained employee.

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:
WorksRight Software
Tramenco
BACK ISSUES
TABLE OF CONTENTS
Common Table Expressions Make Summarizing Data Easy
Windows Power Settings Might Disconnect Ops Console
Reader Feedback and Insights: Book Recommendation

Editors
Ted Holt
Howard Arner
David Morris

Managing Editor
Mari Barrett

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: 4/26/02
Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.