Continuing where we left off in Part 1, a slew of new IBM i services (and enhancements to existing services) were released in IBM i 7.2 TR3 and IBM i 7.1 TR11. This article continues to detail some of the important new services.

As always, keep in mind that just an overview is given here and that the developerWorks documentation or IBM i Services in the Knowledge Center should be consulted in order to understand the full capability of each service.

SYSTOOLS.GROUP_PTF_DETAILS

This view runs a real-time query against the IBM Preventative Service Planning (PSP) website and can indicate

At the recent RPG & DB2 Summit in Dallas, I presented a session that dealt with the use of SQL in CL. One of my examples used the SCHEDULED_JOB_INFO view to retrieve scheduled jobs from the IBM i job scheduler. After the talk, one of the attendees gave me a great idea, and I’ve just got to pass it along to you.

SCHEDULED_JOB_INFO returns the same information that you can see with the Work with Job Schedule Entries (WRKJOBSCDE) command. It’s one of the IBM i Services. The gentleman told me that he and others in his shop had been

The whole purpose of refacing our database is to give proper names to tables and columns. So we have to spend some time ensuring that our names are right. In this article, the second in a series of three, we continue the refacing process by analyzing and correcting our new naming.

In my first article, we had reached the stage where we had extracted table and column definitions into our two conversion tables (TABLE_TRANSLATION and COLUMN_TRANSLATION), as shown below:

Analyzing the Names

Since the new column names were generated from the text descriptions of the original fields, there is