Creating Dynamic Queries
by Bruce Guetzkow

If you've ever created a "one time" query, you know it is extremely likely that you will end up running that query on a regular basis. Typically that means manually changing the selection criteria each time it runs. While Query/400 does allow you to dynamically change the selection criteria, it can only be done if the query is executed interactively, which is usually frowned upon for performance reasons. This article outlines a method for creating a query with dynamic selection criteria and still executing the query in batch. READ MORE >

Security and DDM Files
Hey, Wayne:

While implementing an "application-only access" security program, I ran into a problem with DDM files. The job running in the communications subsystem runs under user QUSER, which typically falls under *PUBLIC authority, so my DDM files cannot be set to *EXCLUDE, as recommended by the application-only-access security strategy. READ MORE >

Calculate Ages with Query/400
Hey, Ted:

I love to read Four Hundred Guru. It always contains great ideas and techniques! We need to calculate an age using Query/400. The database file that we are using has an eight-digit zoned-decimal birthdate field, in the format YYYYMMDD. Can you help? READ MORE >

OS/400 Alert: V5R3 Has Many New Admin and Operations Features
by Shannon O'Donnell

OS/400 V5R3, or, as it is called now, i5/OS V5R3, will contain a veritable fountain of new and enhanced features for the areas of administration and operations. This week, I'll pick three of the more interesting new functions and enhancements in the new operating system. I will highlight more in coming weeks as I get a chance to digest them. I also will go through some new PTFs related to multicast IP addresses and the problems they can cause. READ MORE >

Correction

The article "A Solution to the Numeric Parameter Problem" has been edited since its original publication. The word adds was changed to ands in the following sentence: "The %BITAND built-in function 'ands' these bytes with hex 0F, which zeros out the zone (leftmost four bits) and leaves the digit portion intact." Guild Companies regrets the error. [Change made 5/19/04]

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
Client Server Development
Guild Companies