|
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
|
|
|
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 >
|
|
|
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
|
April 1, 2006: Volume 8, Number 11
March 25, 2006: Volume 8, Number 10
March 18, 2006: Volume 8, Number 9
March 11, 2006: Volume 8, Number 8
February 18, 2006: Volume 8, Number 7
February 11, 2006: Volume 8, Number 6
|
|