• VALUES: A Truly Useless DDS Keyword

  October 26, 2011 Hey, Ted

  We had a recent crisis in our shop. When we dug to the root of the problem, we found that one of our files had an invalid value in one of the fields. I don’t understand why this was the case, because the programmer who wrote the DDS used the VALUES keyword on the field in question. Does the VALUES keyword not prevent invalid data from entering the database? –Paul No, Paul. One would think it does, but use of the VALUES keyword only applies to the workstation controller. That is, only the green-screen interface is restricted by the VALUES

  …

  Read more

• Limiting How Much Memory a Storage Pool Can Allocate

  October 26, 2011 Hey, Joe

  I want to run the i OS Performance Adjuster to automatically allocate system memory to my subsystems. But when I turn it on, most of the memory goes to the *INTERACT storage pool used by the QINTER subsystem. I want to take care of interactive users, but I also want some memory left over for other subsystems. How do I limit *INTERACT from using too much memory? –Jens This sometimes happens with using the i operating system automatic performance adjustment feature. By default in the i 6.1 operating system, the Performance Adjustment (QPFRADJ) system value is set to “2”. This

  …

  Read more

• Return a User Profile Listing to a .NET Client

  October 19, 2011 Hey, Mike

  I am a VB.NET programmer and am looking to retrieve a list of all users and their expiration dates on our AS/400 system. I stumbled across the cwbx library and have been able to connect to our system, but not much else from there. Can you suggest how this info can be retrieved from VB.NET? Thanks. –Elliot Hi, Elliot: The easiest way to retrieve this user info is to use the i/OS Display User Profile (DSPUSRPRF) command and dump the results to a table (also known as an outfile): DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/LSTUSRPRFP) The above command (assuming you have the

  …

  Read more

• Dealing with Faulty Logic

  October 19, 2011 Ted Holt

  Supposedly computer programming is a logical science. One would think, then, that computer programmers would be logical thinkers. It is not so. Let me provide a few examples of illogical thinking taken from real production programs. Then I will show a simple, low-tech way to deal with logical expressions so that they don’t end up illogical. Let’s start with this example taken from fixed-format RPG specs. I suggest you find the bad logic yourself before reading my comments. TYPE IFNE 'A' TYPE IFEQ 'S' XCODE CABNE 'S' CONTIN ENDIF TYPE IFEQ *BLANK XCODE CABEQ 'S' CONTIN ENDIF ENDIF This code

  …

  Read more

• Admin Alert: Adding Redundancy to Power i SMS Monitoring

  October 19, 2011 Joe Hertvik

  In an earlier column, I discussed how to use email addressing to send text message alerts to Power i administrators when a problem occurs. This week, I’ll discuss how to enhance that solution by providing redundancy for i OS text messaging, so that urgent messages can always be delivered regardless of whether or not your email system is running. The Coverage Plan, Phase I In my previous article, I outlined a monitoring plan for using cell phones, email, and text messages to alert administrators when critical iSeries, System i, and Power i events occur. This plan consisted of

  …

  Read more

• Add Outfile Support to Your Applications

  October 12, 2011 Ted Holt

  Note: The code accompanying this article is available for download here. When I compare IBM i to other operating systems, I am amazed. This well-designed, well-built operating system has numerous features that are foreign concepts to other operating systems. One of those features is that of “outfiles”, files that are built by display-type and work-type commands. If you haven’t done so, consider that it may be advantageous to write your own commands with outfile support. In general, programs that write to database files always write to certain database files, and that’s as it should be. A file maintenance program

  …

  Read more

• Skipping Robot/SCHEDULE Runs on AS/400-Class Machines

  October 12, 2011 Hey, Joe

  On our System i 550, we use Robot/SCHEDULE for batch processing. Every so often, we have a programming issue where we have to skip running a job in the middle of a long job stream. The skipped job sometimes has reactive jobs hanging off it. We still want to run the reactive jobs, even when we don’t run their prerequisite job. Got any ideas? –Keith Like many other shops, we also use Robot/SCHEDULE for running batch job streams on our System i and Power i machines. Like you, we’ve encountered the same issue where we want to skip running one

  …

  Read more

• Call Again and Again and Again…

  October 5, 2011 Paul Tuohy

  Note: The code accompanying this article is available for download here. In programming terms, recursion is the process whereby a function may call itself. Traditionally, this is something we are not used to in RPG. Programs and subroutines cannot call themselves. Or if you did somehow manage it (and you could), you would get unpredictable results. But the introduction of subprocedures opened up the possibility of using recursion because subprocedures can call themselves. It is usually very difficult to come up with practical examples of using recursion, and most of those examples are usually very specific to an application.

  …

  Read more

• Another Way to Pass Parms to SBMJOB

  October 5, 2011 Bruce Guetzkow

  Note: The code accompanying this article is available for download here. A couple of years ago I needed to develop a process where a group of items could be selected from a screen and a report listing those items could be generated. On the surface, a simple task. Of course, if you give a mouse a cookie, they’re going to want a glass of milk, or another report. . . and another. Again, not too complicated. All that should be needed is a way to submit a call to a variable list of programs. As long as each program

  …

  Read more

• Admin Alert: How to Retrieve Password Parameters for Auditors

  October 5, 2011 Joe Hertvik

  Your organization’s fiscal year may have ended on September 30. Meaning you could soon be visited by auditors looking for information on how your organization operates its AS/400-class machine (iSeries, System i, Power i). Your auditors will be particularly interested in your password configuration parameters and whether they meet standards. To that end, here’s a quick drill for retrieving password setup values at audit time. What Auditors Want Auditors generally require you to provide the following sets of password related parameters. Your password configuration parameters–The rules users follow for creating passwords. Configuration and program code for Password Validation Program

  …

  Read more

Previous Articles Next Articles