I hope this question is not too simple for a newsletter that claims to be for gurus. An RPG program or module retains variables, open data paths, and other resources from one invocation to the next, as long as the LR indicator is not on. CL programs and modules, on the other hand, suffer from Alzheimer’s disease. They don’t remember anything from one invocation to the next. How do you handle this limitation?

–Richard

I can help you with part of this problem, Richard. Create a temporary data area to hold the variable values from one call to the next.

The SQL sorting tip you published on September 13 was a good one. I had seen a similar tip written by Craig Mullins in Quest Software’s Pipeline Newsletter. Mullins had two other interesting tips on the same page. I thought your readers might like to see them as well.

–Tom

The Web page to which Tom refers is at http://www.quest-pipelines.com/newsletter-v7/0606_F.htm. Craig Mullins uses the technique about which I wrote to sort data on three-letter day abbreviations.

Another tip he presents involves using the REPLACE function to remove extra spaces within a character string. IBM added the REPLACE function

When installing third-party i5 software, most vendors provide a list of required i5/OS licensed programs that must also be installed so that their product works properly. However, not every IBM licensed program will always be available on your i5 or iSeries partition, and sometimes you have to locate installation media to add additional products. This week’s Admin Alert will help guide you through that process.

Introducing Our Example

To illustrate how to install i5/OS licensed program products (LPPs), I’ll review an example that recently happened in my shop. All the concepts described in this situation are applicable to most i5/OS