FHG Volume: 11 Archives - Page 11 of 12

OUTQ vs. PRTDEV

February 16, 2011 Hey, Ted

Several CL commands–Create User Profile (CRTUSRPRF) is a good example–have two parameters that control the destination of printed output. Where is the need for both print device and output queue? Can you explain the role of these parameters in determining the destination of output?

-Tim

I know of no need to use both print device and output queue (“outq”) parameters. I have always managed fine with outq’s only. The System/38, one of the predecessors of the AS/400, used outq’s exclusively. I understand that IBM added the print device option to support software that had been developed for the AS/400’s other

…

Admin Alert: Six Techniques to Prevent Power i Upgrades from Slowing Down

February 16, 2011 Joe Hertvik

When I’m ready to perform a significant software or hardware upgrade, I use a series of techniques to cut upgrade time, avoid mistakes, and avoid delays. This week, I’ll review six of those techniques in the hope that you can use some of them to make your next Power i upgrade go easier.

Keeping the Upgrade from Slowing Down

I’ve always found that you can never increase Power i upgrade speed, you can only stop an upgrade from slowing down. In no particular order, these six tips can help you reduce the amount of waiting time in the Power i

…

Synchronize Your Outlook Calendar with DB2 for i ERP Data

February 2, 2011 Hey, Mike

We would like to merge the Resource Assigned Calendar from our JDE Service Management software with the Outlook Calendar so that we only need to look in one place. We also want to receive an email from Outlook and create a case.

How can we approach this?

–Robert

Hi, Robert:

As always, there is more than one way to skin a cat, and this calendar synchronization task is no exception.

The approach I will be taking to solve this problem is to allow an Outlook client to monitor the ERP system’s calendar table using Visual Basic for Applications (VBA) coding.

…

Another Reason Why Function Subprocedures Should Not Modify Their Parameters

February 2, 2011 Ted Holt

I’ve never liked the idea of functions modifying their parameters. It seems to me that a function should accept zero or more input values and return one and only one value. Modifying a parameter is a roundabout way of returning another value. While looking for something in the ILE RPG reference recently, I found yet one more reason why it’s not a good idea for a function to modify a parm.

This is IBM‘s example code with my modifications to make it run.

Figure 189. Sample coding of a call with side effects 
 *..1....+....2....+....3....+....4....+....5....+....6....+....7...+....
H dftactgrp(*no) actgrp(*new)

D fn

…

Admin Alert: QPWDRULES Rules!!! Opening Up User Password Options with i 6.1

February 2, 2011 Joe Hertvik

Like many i/OS shops, we recently started upgrading several systems from i/OS V5R4Mx to i 6.1. One of the more interesting features about i 6.1 is the new Password rules (QPWDRULES) system value, which allows you to control and extend password composition settings to designate all your password rules in one place and to include password composition options that weren’t available in earlier versions of the operating system.

What is QPWDRULES?

Think of QPWDRULES as a password composition rule aggregator. In earlier i/OS and AS/400 operating systems, IBM did not consolidate password composition system values in one place on

…

A Reusable Routine for Doubly-Linked Lists, Part 2

January 26, 2011 Miguel Ortiz Martín and Ted Holt

Note: The code accompanying this article is available for download here.

In Part 1 of this series, we introduced several concepts, such as managing external storage and defining comparator procedures, that are required for defining a reusable routine for managing doubly-linked lists.

In this second part, we:

Detail the procedures that create, delete, and manipulate reusable doubly-linked lists.
Tell you about the source code and how to create a service program.
Show you an example of how to use the doubly-linked list service program in your applications.

Creating and Destroying a List

Let’s begin with a list of the

…

Don’t Let Users Wreck Their Joins

January 26, 2011 Ted Holt

You’re swamped with work, and here comes Harold in Accounts Receivable yet again for help with some query he threw together that doesn’t work correctly. Harold’s not a bad guy–his wife, his kids, and his dog adore him. He just doesn’t understand computer stuff. Here’s a way you can help him help you.

Harold’s problem is that he doesn’t understand how to join files properly. What you need is a way to store join field information on the system. That is, you need a way to store the fact that file A and file B join over field C and

…

Why Can’t I Move System Memory Between Partition?

January 26, 2011 Hey, Joe

I’m using the Web interface on my Hardware Management Console (HMC) to move memory between my Power i partitions, and it keeps timing out before completing the move. What’s going on and why can’t I move memory between my partitions?

–Sven

There are a number of reasons for moving memory between i/OS partitions. I’ve frequently moved memory and CPU from one partition to another during an upgrade, to help speed the process along faster. A few years ago, I also set up an HMC to automatically shift memory from our development box to our production system and back again during

…

A Reusable Routine for Doubly-Linked Lists, Part 1

January 19, 2011 Miguel Ortiz Martín and Ted Holt

In Implementing Linked Lists in RPG, Ted Holt explained that a linked list consists of a sequence of data records, or nodes, where each node keeps a reference–a pointer–to the next node in the sequence. This sequence might or might not be sorted. Due to the fact that each node points only to the next node in the sequence, this kind of list is also called a singly-linked list.

Doubly-linked lists differ from singly-linked lists in that each node of the list keeps pointers to both the previous and the next nodes in the sequence. Whereas a singly-linked list

…

Cleaning Up RSE Detritus

January 19, 2011 Hey, Ted

Note: The code accompanying this article is available for download here.

Hey, Ted:

While doing some year-end house (disk) cleaning, I ran across the temporary source files that CRTSQLRPGI uses when run from RSE (WDSC or RDx), which are named EVFTEMPF01 and EVFTEMPF02. I knew about these files but never paid much attention to them. Today I discovered that there were 20 files (10 of each type) with total size of 45MB.

I wrote the attached clean-up program and a command interface. I scheduled the command to run every weekend.

I didn’t clear the file at the end so

…

Previous Articles Next Articles

Search for: