FHG Volume: 14 Archives

End of Year Feedback

December 17, 2014 Ted Holt

It’s been a wonderful year, in spite of all the difficulties, problems, and vicissitudes of life that I would rather not have faced. I appreciate all the email that you’ve sent in response to the articles we published. To know that we’ve done something to make someone’s life easier and better gives me great satisfaction. I’d like to share some of your comments with your fellow Four Hundred Guru readers. May you enjoy the holidays, and may 2015 be your best year ever.

Hey, Ted:

I just read Use Wireshark To Diagnose IBM i Communications Problems. You can bypass

…

In Praise Of One-Off Tools

December 17, 2014 Ted Holt

This is the last issue of Four Hundred Guru for 2014, and in the last issue of a year I try to write about something unusual, something different from the routine stuff we usually run in this august publication. I worked on several interesting projects in 2014, but the one I want to talk about today will seem really retrograde to you. I wrote a bunch of System/36 RPG II programs. How I wrote them is the real story.

In early 2014, a friend of mine emailed a request. A client of his, who still runs an S/36, was going

…

Admin Alert: What Should an IBM i Administrator Do, Part 2

December 17, 2014 Joe Hertvik

Last week, I discussed why shops still need IBM i administrators and started describing a checklist of tasks that are well-suited for less experienced administrators. My checklist showcased duties that can easily be turned over to lower level administrators, leaving more experienced people free to complete projects that benefit your organization. Today, I’ll complete describing the IBM i administrator checklist.

The Checklist Continued

As discussed last week, here’s a starter list of duties that can easily be turned over to an IBM i system administrator.

IBM i user provisioning
Auditing the system
Software setups and on-going software database maintenance
Backup

…

Fuzzy Matching In RPG

December 3, 2014 Ted Holt

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

SQL allows you to use wildcard characters with the LIKE operator to search a column for a pattern. As they say in the GEICO commercials, “Everybody knows that.” Well, did you know you can do the same thing in RPG programs?

If you’re not familiar with LIKE, read about it here. You can use the LIKE operator to find data with inexact matches. For instance, find all customers whose names contain “ACME”.

select * from cust
 where name like '%ACME%'

   ID  NAME
=====  ==========================================
19883  ACME

…

TR8 DB2 For i Enhancements, Part 2

December 3, 2014 Michael Sansoterra

In the first part of this series, I introduced several of the DB2 for i enhancements made in IBM i 7.1 Technology refresh 8 (and in IBM i 7.2).

These enhancements were of interest to developers and administrators. Likewise, this second set of enhancements we are about to review will be of interest to developers but may hold even greater interest for those in an administrative role.

QSYS2.GET_JOB_INFO enhancement

This DB2 for i service table function has two new enhancements:

1. The job parameter now accepts the special value ‘*’ to return information about the current job.

2. New

…

Admin Alert: What Should An IBM i Administrator Do, Part 1

December 3, 2014 Joe Hertvik

With remote monitoring and lights-out data centers, people think there isn’t a need for system operators any more. And they’re right-ish. There’s little need for low-skill operators whose main function is watching the system and printing reports. But IBM i operations work isn’t obsolete; it’s just changed into a systems management function. Given that, here’s my take on tasks a lower level IBM i system administrator can perform in 2015 and beyond.

Why You Need Day-To-Day IBM i Administrators

For IBM i shops, it’s important to define the difference between project management and day-to-day operations. IBM i project managers are

…

TR8 DB2 For i Enhancements, Part 1

November 12, 2014 Michael Sansoterra

IBM i 7.1 Technology refresh 8 was released on June 6, 2014, and it has another group of small database enhancements worth reviewing. IBM i 7.2 users will find that they already have these features. This tip assumes that you have IBM i 7.2 or IBM i 7.1 with Database Group PTF Level 29 or higher installed.

QSYS2.GENERATE_SQL Stored Procedure

This is one sweet new stored procedure IBM has given us. Its purpose is to programmatically retrieve SQL source code into a source member.

This procedure can accept a boatload of parameters as shown below. Many of the parameters control

…

SQL Functions You Didn’t Know You Had, Part 2

November 12, 2014 Ted Holt

In SQL Functions You Didn’t Know You Had, Part 1, I showed you how to make an SQL function that runs a subprocedure in a service program. What I showed you is fine up to a point, but it’s not the entire story.

The technique that I shared with you breaks down when null values enter the picture. First, the subprocedures in the ADDR service program cannot accept null arguments into parameters. Second, those subprocedures cannot return a null value to the SQL query.

These behaviors are specified in two clauses of the CREATE FUNCTION statement:

PARAMETER STYLE GENERAL

…

Flip This Job Number: Adjusting The Job Queue Control Utility For Job Number Resets

November 12, 2014 Hey, Joe

I just read your article on creating a skeleton program for controlling IBM i job queues creating a skeleton program for controlling IBM i job queues. In your job queue physical file (WRKJOBQPF) that contains the list of jobs inside a specific job queue, you keyed that file by the six-digit job number of each job in queue. I think that’s a bad idea. Here’s why. . .

–Charles

Charles continues:

“On busy systems where the job number can flip (over to 000001) daily, it introduces a period of time where the results will not be desirable. Needless to

…

SQL Functions You Didn’t Know You Had, Part 1

October 22, 2014 Ted Holt

What if I told you that you may have some potential powerful SQL functions on your system that you are not aware of? What if I told you that I have no idea what those SQL functions are named? What if I told you that you could easily use existing RPG routines in SQL queries? Would you be interested?

(Take a tip from the Little Rascals (AKA Our Gang) and say, “And how!”)

It’s easy to make SQL functions out of the subprocedures in service programs. To illustrate, here’s the source code for an RPG module from which a service

…

Search for:

Content archive

The Four Hundred
Four Hundred Stuff
Four Hundred Guru

Content archive

Recent Posts

Subscribe

Pages

Search