• Guru Classic: More iSphere Goodies

  March 4, 2020 Susan Gantner

  This Guru Classic tip is my third in a series exploring the iSphere RDi plug-in. In this tip I’ll cover two additional ways in which iSphere expands the RDi toolset. There are a few details that I’ve updated in this new version of the tip due to updates in either RDi or the iSphere tool itself. Plus I have added an additional tip based on how I’ve seen one of these features utilized.

  Binding Directory Editor

  I’ve long been baffled at the lack of support in RDi for binding directories; it seems like something modern developers certainly use. In the …

  Read more

• Guru Classic: Tuning SQL Environments On i

  March 4, 2020 Paul Tuohy

  Author’s Note: This article was originally published in November 2015. This was one of the first DB2 for i Services that I used in anger. I have used a lot since.

  One of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that piques your interest, it invariably clashes with when you are speaking. But every now and again, the scheduling gods work in your favor. Such was the case when I spoke at the excellent International i-Power 2015 conference at Wyboston Lakes Executive Centre in the UK. …

  Read more

• Guru Classic: Overlaid Packed Data In Data Structures

  March 4, 2020 Jon Paris

  When I re-read this tip while looking for a “Classic” candidate, I was reminded that the underlying issue it addresses, namely how data is actually stored in an RPG program, is one that many RPG programmers don’t really have a firm grip on. That alone made it a good candidate. But perhaps even more important is demonstrating this topic to the many new programmers coming onto the platform. Unlike those of us who started off with assembly languages, C, RPG, or COBOL, modern programmers trained in C#, Python, or PHP have never had any need to understand the mechanics of …

  Read more

• Guru Classic: Find a View of a View of a View. . .

  February 5, 2020 Paul Tuohy

  Author’s Note: This article was originally published in October 2014. This stored procedure is something I use a lot and has saved me from accidentally deleting dependent views more than once. Basically, I call it before I ever drop a view.

  SQLs Data Definition Language (DDL) offers many great features, one of which is the ability to define a view of a view. This can lead to simple or complex structures making use of views of views of views of . . . you get the idea.

  But one of the difficulties with this technique is that, once created, it …

  Read more

• Guru Classic: A Bevy Of BIFs — Updates

  February 5, 2020 Jon Paris

  In my previous tip I returned to the “Bevy” series to tell you about the latest addition to the family: %ScanRpl. Shortly after completing that tip I realized that there have been a number of more recent BIFs such as %SubArr and some enhancements to existing BIFs like %Trimx that seem to have escaped people’s notice. In this tip I attempt to fill those omissions.

  %Trim: Specify Characters to Trim

  Let’s start with a BIF that hopefully you are all familiar with: %Trim. Before going any further I should point out that when I say %Trim, I am referring to …

  Read more

• Guru Classic: Looking For Stuff With iSphere

  February 5, 2020 Susan Gantner

  In my last Guru Classic tip I introduced you to the iSphere RDi plug-in. In this tip I’ll cover a few other features in iSphere that I find very useful. This time I’ll focus on a couple of options there that can help you search for things and subsequently edit them. The two things we’ll be searching are source members and message files.

  This tip contains a few updates to the original version of this article due to some iSphere enhancements made in the last few years. I’ve also included a few changes based on my experiences using these great …

  Read more

• Guru Classic: iSphere Plug-in Expands RSE/RDi Toolset

  January 8, 2020 Susan Gantner

  My series of three Guru tips on the free iSphere plug-in first appeared in 2015. Since I still find that most RDi users haven’t heard of it, I’ve decided to repeat the series as Guru Classics. I’ve made a few updates to this first one in the series due to enhancements made to both RDi and iSphere in the intervening years.

  Followers of my Guru tips know that I’m a big RDi fan. These days I would be lost trying to write or maintain RPG code without things like RDi’s Outline, Error feedback, editor filtering, and Undo. But you know …

  Read more

• Guru Classic: A Bevy Of BIFs – %ScanRpl (Scan And Replace)

  January 8, 2020 Jon Paris

  This gem of a BIF was introduced with the V7.1 release and so was not available some five years ago when I wrote my original Bevy series of tips. Now that most active development shops are running V7.1 and later it seems a good candidate for a “Classic” to remind readers of its capabilities. The intervening years have not dimmed its utility and it remains one of my all-time favorite BIFs.

  Simply put, %ScanRpl will search a target string for a given character sequence and replace it with another. Not only that but it will then continue to search through …

  Read more

• Guru Classic: Don’t Ignore the View

  January 8, 2020 Paul Tuohy

  Author’s Note: This article was originally published in April 2009. The use of DDL and embedded SQL have come a long way since then but the basic premise of the article still applies. I have removed the embedded SQL example using a SELECT * since this is a style that I no longer recommend (from the point of view of self-documenting code, possible performance gains and breaking old habits of thinking in records). I also changed the example of reformatting a numeric date column to use a DATES table as opposed to functions (a faster and better approach). I removed …

  Read more

• Guru Classic: Looking for Commitment, Part 3

  August 14, 2019 Paul Tuohy

  As companies look to modernize their applications, commitment control can play an integral role. This set of three articles about commitment control was originally published in March of 2009. (See Related Stories below.) The content of the articles has been updated for free-form RPG. In this article, I will take a closer look at how commitment control works by looking at the journal entries for commitment control. I will also discuss the LCKLVL and CMTSCOPE parameters on the STRCMTCTL command.

  Commitment Control And Journals

  Commitment control is dependent upon the use of a journal. A journal is used in conjunction …

  Read more

Previous Articles