|
New this month at the Midrange Alliance:
· Free Gartner Whitepaper on 99,000 CPW modernization project
· Free Whitepaper on modernizing your JD Edwards system
· Free Training on integrating System i with Windows
To download these papers and much more visit the Midrange Alliance at:
www.MidrangeAlliance.org
Integration Enhancement Transformation
|
|
|
|
Fix Decimal Data Errors
by Bruce Guetzkow
I have seen requests many times in the forums from programmers asking how best to handle data with invalid decimal data. Typically this type of error is first discovered when a program ends abnormally. I have found this problem occurs most often with data received from outside sources: customers and vendors. Many times this data comes from systems other than a System i. I've developed a command to identify and (optionally) "fix" errant data. READ MORE >
|
|
|
Joining on Mismatched Values
Hey, Ted:
Like many shops, we have a mixture of database files that we have acquired from different sources due to mergers and acquisitions over the years. Getting things to match up is challenging, to put it mildly. I have two files that contain warehouse code fields, but the codes do not match exactly. In one file, a certain warehouse is indicated by the letter T. In the other file, the same warehouse is the character 1 (one). All other warehouses have the same codes in both files. READ MORE >
|
|
|
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
|

|
|
|
Admin Alert: Alternative Ways to Print PC5250 Screens
by Joe Hertvik
Most PC5250 green-screen users like using the Print Screen icon for sending screen shots to networked printers. However, there are two lesser-known PC5250 screen capture functions that can send screen shots to i5/OS output queues or to collect screen shots and print them as a group to a Windows networked printer, rather than printing each shot individually as they do when using Print Screen. 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
|
IT Jungle Store Top Book Picks
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95
|
|
June 9, 2007: Volume 9, Number 23
June 2, 2007: Volume 9, Number 22
May 26, 2007: Volume 9, Number 21
May 19, 2007: Volume 9, Number 20
May 12, 2007: Volume 9, Number 19
May 5, 2007: Volume 9, Number 18
|
|
|
|