fhg
Volume 6, Number 14 -- April 5, 2006
Sponsored By
WORKSRIGHT SOFTWARE

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?

 

We can HELP!
We have affordable AS/400 software
and data to do all of the above.
Call us for 30 days FREE.

 

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com


Sponsored By
ADVANCED SYSTEMS CONCEPTS


SEQUEL can be used for virtually ALL data access functions on the iSeries.

 

A Windows-based user interface makes it easy to design queries and reports.

 

SEQUEL offers executive dashboards, drill-down data analysis and run-time prompts to deliver important iSeries data to managers and other non-technical users.

 

E-mail and FTP delivery let you deliver information to remote users and servers.

 

www.asc-iseries.com


Avoiding the Green Screen of Death in RPG Programs
by Ted Holt

Although I have been using various versions of Microsoft Windows since the early 1990s, I am still not impressed when I gaze upon that phenomenon popularly known as the "Blue Screen of Death." In the same way, I do not think iSeries users are impressed when they see the Display Program Messages panel, or as I call it, the "Green Screen of Death." Fortunately, showing users the Display Program Messages panel is almost always avoidable. READ MORE >

Change a Substring with SQL
Hey, Ted:

I am trying to change part of a character field with an SQL UPDATE command. However, my SQL command gives me an invalid token error at the opening parenthesis of SUBSTR in the SET statement. Is there a rule that you can't use SUBSTR in a SET statement? If so, do you have a workaround? READ MORE >




Sponsored By
TURBOGORILLA

iSeries PC-Engine Suite
Infuse Legacy Green-Screen Apps
with PC-Power and No Coding!

 

Open Web pages, display Images, display Interactive Satellite Maps using Geo-Coding, create MS Word docs, convert spooled files to PDF, search Google from your own legacy apps, manage software and hardware assets of all the PCs in your network, and more!

 

For one low price of $495 you get a complete iSeries PC-Engine Suite that includes Google Earth, UPS Package Tracker, and Yahoo! Maps.

 

Download a full function free trial version at:
www.turbogorilla-software.com




Admin Alert: Protecting Your System from Critical Storage Errors
by Joe Hertvik

Like all computers, i5, iSeries, and AS/400 systems are vulnerable to system failures when their disk storage units fill up. i5/OS operating system performance rapidly degrades after system storage reaches 90 percent capacity, and the system can crash--or turn itself off--when storage passes 95 percent. Because of this, it's wise to understand how your system handles critical storage situations and how it can alert you when disk capacity problems appear. READ MORE >



Reader Feedback and Insights

We value your feedback and insights.  Feel free to send a letter to the editor.  Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >


 
Senior Technical Editor: Ted Holt
Technical Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

 

Sponsored Links

California Software:  Migrate iSeries apps to Windows, Linux, or Unix
Computer Keyes:  Rapidly convert *SCS printer files into black and white or full color PDF documents
Bug Busters Software Engineering:  Quality software solutions for the iSeries since 1988

 


 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement