FHG Volume: 11 Archives - Page 12 of 12

Solving PC5250 Printing Problems and Tweets About i/OS Error Messages

January 19, 2011 Hey, Joe

I’m having problems with printing my iSeries Access Personal Communications PC5250 screens. Every time I print a screen, it comes out in a large font and the letters run on top of each other, making the text unreadable. How can I straighten out this issue? We’re running iSeries Access for Windows V5R4M0.

–Bob

This is an issue with your PC5250 setup and you should be able to solve it in one of two ways.

The first thing you’ll want to check is your PC5250 Page Setup function. The Page Setup function allows you to designate the following standard text parameters

…

Implementing Binary Trees in RPG

January 12, 2011 Ted Holt

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

Last week, I wrote about linked lists. Each node in the list points to another node. Binary trees differ from linked lists in only one way–each node has two pointers to other nodes. How you label these pointers is up to you, but most people choose to call them left and right.

Here’s a data structure that defines a node with left and right pointers.

     D Record          ds                  qualified
     D   Name                        20a
     D   City                        12a
     D   Left                          *
     D   Right                         *

A node that points to one

…

Closing the Gaps

January 12, 2011 Hey, Ted

We have a database file to which records are added throughout the day. The key is a five-digit packed decimal whole number, and the program that writes to the file increments this number when adding a new record to the file. During the day, another program processes and deletes records throughout the file, leaving gaps between sequence numbers. At the end of each day, we would like to renumber the remaining records, beginning again at sequence number one, to remove the gaps and be prepared for a fresh start the next day. Can we use an SQL UPDATE statement to

…

Admin Alert: Basic i/OS Error Monitoring and Response, Part 2

January 12, 2011 Joe Hertvik

Last week, I began outlining a basic plan for monitoring and answering i/OS error messages, allowing you to resolve system and programming issues without having dedicated 24x7x365 personnel on site. That article focused on detection and notification of errors. This week, I’ll focus on extending the plan to include allowing responders to correct issues from anywhere, to automatically answer error messages without human input, and some other things to do after the error message is resolved.

The Basic Structure of i/OS Error Monitoring and Response

As outlined in Part 1, an i/OS error monitoring and response system contains

…

Implementing Linked Lists in RPG

January 5, 2011 Ted Holt

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

In Basing Pointer Variables in RPG: The Basics, I wrote about the fundamentals of using basing pointers, a concept I came to understand when I learned Pascal. In this article, I continue my discussion of the use of pointers by showing how to implement linked lists in RPG.

Before I start into the meat of the article, let me first give credit where credit is due. I had pondered the question of building linked lists in RPG for some time, but I had not devised a way

…

How To Rename Your Local Database

January 5, 2011 Hey, Ted

When I start up an interactive SQL session I see “Current connection is to relational database Sxxxxxxx.” Sxxxxxxx is our serial number. Is there a way to change the relational database name to something a little more meaningful?

–David

Use the Work with Relational Database Directory Entry (WRKRDBDIRE) command. The entry you need to change is for remote location *LOCAL. For more information about WRKRDBDIRE, see Using the WRKRDBDIRE command at IBM‘s Info Center.

–Ted

That solved the problem. It was little scary because I couldn’t change the name, but had to delete the existing one

…

Admin Alert: Basic i/OS Error Monitoring and Response, Part 1

January 5, 2011 Joe Hertvik

I once worked for an insurance company that had a 24x7x365 operations staff. When iSeries error messages occurred, the operations staff mostly handled problem resolution and other staff members were rarely alerted. Sadly, this world no longer exists and it is now left to i/OS administrators to detect when system errors occur on a 24×7 basis and to react to them in a timely manner so that production isn’t delayed.

Toward that goal, this week and next, I will describe a basic game plan for managing i/OS error messages so that all system and programming issues are quickly handled without

…

Implementing Linked Lists in RPG

January 5, 2011 Ted Holt

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

Before I start into the meat of the article, let me first give credit where credit is due. I had pondered the question of building linked lists in RPG for some time, but I had not devised a way

…