Stop Hard-Coding Before It Stops You
by Kevin Vandever

It drives me nuts. How can it be that month-end reports don't run correctly all of sudden? These same programs run every month, and no one has modified them in years. Now the numbers are all wrong, and the you-know-what has rolled downhill, all the way from the CFO's desk, and has landed smack dab in the earpiece of my telephone. Ouch! Yuk! READ MORE >

An Alternative to Externally Described Printer Files
by Cletus the Codeslinger

There is no shortage of ways to build a report from an iSeries database. IBM offers Query/400, Query Management, and SQL/400, but they're all limited in one way or another. For example, Query/400 has to be told to read the library list, it has no conditional processing, it has limited calculation abilities, and passing parameters to a Query/400 query is hardly intuitive. There are many third-party query packages. Some run on the iSeries; some run on PCs. Many overcome the limitations of IBM's query offerings. READ MORE >

Performing Numeric Bitwise Comparisons in SQL and RPG
by Michael Sansoterra

In the iSeries world, there isn't a high demand for propeller-heads to write software that does bit manipulation. I've used bit manipulation on the iSeries a handful of times--once while writing a BASE64 routine to create binary e-mail attachments, once while communicating with a shop-floor device, and a few of other times for doing things like fixing decimal data errors. READ MORE >

Welcome to Wayne O. Evans: Security Guru

Security questions for Four Hundred Guru are being answered by Wayne O. Evans, one of the top OS/400 security experts in the world. Wayne designed security features on the AS/400 and S/38 during his 27 years at IBM and is a well-known and highly respected consultant, author, educator, and speaker. His security tips will become a regular item in Guru newsletters. This week's tip covers lock functions. READ MORE >

  OS/400 Alert: iSeries Movies, Tools, and More
  by Shannon O'Donnell

If you've ever wondered what IBM would do if it had a really great computing platform, a video camera, and a budget of at least six dollars, then have we got some great news for you! IBM has gotten into the movie business by releasing a series of videos showcasing the reliability of the venerable iSeries. Also in this issue, we alert you to a free study offered by IBM that might help you convince management to consolidate all those Linux and Intel-based servers onto the iSeries. 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 >

Advanced Systems Concepts
Guild Companies
*noMAX
WorksRight Sofware
COMMON