• Guru Classic: A Bevy of BIFs, %XLATE and %REPLACE

  March 6, 2019 Jon Paris

  Author’s Note: I’m revisiting this classic tip since the original was written back in 2009, long before the introduction of free-form data declarations. In addition, I’ve updated this tip to point to the new %SCANRPL BIF, which impacts this scenario. And, of course, I still regularly encounter RPGers who are confused by the differences between the %XLATE and %REPLACE built-in functions (BIFs). Part of that confusion of course is the result of wishful thinking on the part of those frustrated by the limitations of %XLATE!

  The first thing to remember when deciding which function to use is that %XLATE operates …

  Read more

• Guru: Why And How Not to Use The Aretha Franklin I/O Method

  March 4, 2019 Ted Holt

  The Aretha Franklin I/O Method is still used heavily in RPG shops even though a better method has existed for decades. In the following paragraphs, I explain the Aretha Franklin I/O Method, tell you why you should not use it, and show you the superior method.

  First, let me give credit where credit is due. Although I had been using the Aretha Franklin I/O Method since my System/34 days, I never knew it by that name. Then Dan Cruikshank (now retired) of IBM informed me of this terminology. Here’s how it works:

  Assume an RPG program that needs data from …

  Read more

• Four Hundred Monitor, March 4

  March 4, 2019 Jenny Thomas

  “Dear March, come in!” Readers of Emily Dickinson might recognize the first line of one of her many poems. Although it is unlikely she was thinking of the computing industry as she welcomed the new month, the sentiment is fitting as we already enter the last month of the first quarter of the year. 2019 has been a busy one for IBM as it continues to make headlines throughout the computing world, which will hopefully result in good numbers coming out of Q1. You can count on IT Jungle to be watching for that news, and in the meantime, you …

  Read more

• Building A Positive Culture of Learning On IBM i

  February 18, 2019 Alex Woodie

  How do you motivate IBM i programmers to keep learning new technologies, long after they have mastered the RPG skills they use the most? There’s no simple answer to that question, which was the topic of a recent conversation IT Jungle had with PHP on IBM i guru Alan Seiden and Heidi Schmidt, the head of PKS Software.

  IBM i shops face several interrelated problems when it comes to their personnel, which traditionally is one of the biggest line items in the IT budget. These challenges include: the aging of IBM i professionals; the retirements of baby boomer-aged personnel; the …

  Read more

• Guru: Change XML Elements in SQL

  February 18, 2019 Paul Tuohy

  Over the last few years, it has become more common to store XML or JSON in a column in a table. Whereas SQL provides all the necessary functions to construct/deconstruct XML or JSON from/to relational data, it does not provide an easy means to change the contents of an element. In this article, I am going to demonstrate a technique for changing the contents of an XML element using an SQL stored procedure.

  Just to provide some background, I was recently working on a project where DB2 XML Extender functionality was being replaced with the standard XML functions. The project …

  Read more

• Guru Classic: Triggers – Allow Repeated Change

  February 13, 2019 Paul Tuohy

  Author’s Note: This article was originally published in November 2013. This has always been one of my favorite techniques for data modernization. I only wish I had thought of it back in the days of Y2K! The content of the article has been updated for free form RPG and some of the coding enhancements that have been introduced into RPG since 2013. 

  Recently, during a modernization project, I have been making use of the Allow Repeated Change (ALWREPCHG) option with before triggers. ALWREPCHG allows a before trigger to make changes to the record being inserted or updated, and that lets …

  Read more

• Guru: Open Access To The Rescue

  February 11, 2019 Jon Paris

  Recently I came upon a couple of questions on internet lists asking for an easy method to create flat files in the IFS. Not CSV files, but rather simple text files where individual data items are in fixed character positions. Various somewhat convoluted solutions were offered to the requestors, but to me this problem shouted “Open Access!”

  So, I set about quickly building an Open Access (OA) handler to perform the task. I find OA really useful for this kind of job because, once the handler is written, creating these kinds of files in the future become a trivial task, …

  Read more

• More IBM i Predictions For 2019

  February 6, 2019 Alex Woodie

  We kicked off our 2019 soothsaying last week with predictions from IBM i leaders on what the New Year will bring. We keep the ball rolling this week with another batch of predictions from our friends around the IBM i community.

  According to Alison Butterill, IBM‘s the program director for offering management for IBM i, the platform will build off the momentum generated with last year’s 30th anniversary celebrant.

  “The excitement begun in 2018 as we highlighted client innovation around the world will continue into 2019,” Butterill says. “The momentum continues to grow as clients are looking at ways …

  Read more

• Inside The Latest ALL400s Report

  February 6, 2019 Alex Woodie

  In early 2018, John Rockwell started a survey from his ALL400s website in an attempt to glean more information about the state of midrange community. Many of the questions are about which products IBM i professionals use, but the survey also digs into other aspects of the relationships that people and organizations have with the platform, including plans to migrate off IBM i.

  According to the latest ALL400s survey of the midrange community, more IBM i shops say they have no plans to move off the platform. It was a small increase — from 57.5 percent last April who said …

  Read more

• IBM i Has Been Getting With The Program For Years

  February 4, 2019 Timothy Prickett Morgan

  There are many things that one could constructively criticize IBM about when it comes to the Power Systems platform running the IBM i operating system. But, in recent years at least, one of those things would not be – and could not be – that the company has not done enough to embrace the most important elements of the modern programming toolbox.

  In fact, the company has done and increasingly good job of embracing and extending the compilers, interpreters, frameworks, and models of the programming languages that have gone mainstream since Java first took the stage at the beginning of …

  Read more

Previous Articles Next Articles