• Guru: Calling RPG Programs From Python, Part 2

  April 27, 2020 Mike Larsen

  In Calling RPG Programs From Python, Part 1, I showed how to call an RPG program from a Python script passing single string parameters as input and output. In the second part of this series, I’ll make the process a little more robust by passing a data structure to the RPG program.

  The first part of the Python script (shown in the first piece of code below) imports the itoolkit modules and assigns them to local names. Next, I set up the first command that adds a library list entry to where the RPG object resides.

  from itoolkit import 

  …

  Read more

• Here’s What’s In the Latest IBM i Technology Refreshes

  April 15, 2020 Alex Woodie

  As expected, IBM today officially unveiled its spring Technology Refreshes for IBM i. Among the goodies that will become available for IBM i 7.4 TR2 or IBM i 7.3 TR8 (or both) are enhancements to Db2 Mirror, a new approach to tape library virtualization, improvements to open source, and new features and functionality around Db2, RPG, RDi, and security, too.

  Months ago, IBM execs circled April 14 on their calendars as the day for the big IBM 7.4 TR2 and IBM i 7.3 TR8 reveal, with the idea that the following week’s POWERUp conference in Atlanta, Georgia (now canceled, but …

  Read more

• IBM i Can Thrive Under New CEO, Arvind Krishna

  April 8, 2020 Alex Woodie

  Arvind Krishna took the reins as CEO of IBM on Monday, marking the changing of the guard at one of this country’s foremost tech firms. But this is no ordinary switch, as Krishna must immediately navigate IBM through an extraordinary crisis that combines technological and social upheaval along with a new business climate. If given the proper attention, the IBM i platform has the chance to shine.

  A new IBM CEO is a momentous event in and of itself. Since Thomas Watson founded the company in 1914, there have been only nine other CEOs at the Armonk, New York, company …

  Read more

• imPower Technologies Embraces Switch to Online Learning

  April 8, 2020 Alex Woodie

  Traditional schools around the world are in turmoil as a result of the COVID-19 lockdown and the sudden switch to online learning. For Jim Buck and his new IBM i training venture, imPower Technologies, the sudden popularity of virtual education validates the work he and his colleagues have done to build an Internet-based IBM i education operation.

  “We’ve been preparing for this unknowingly for years now,” imPower Technologies Chief Operating Officer Michelle Lyons says. “Had we known, we couldn’t have prepared better.”

  Buck and Lyons started building imPower Technologies nearly three years ago to provide an online vehicle to deliver …

  Read more

• Guru: SQL Checks For Control Breaks

  April 6, 2020 Ted Holt

  A control break occurs when the combined value of one or more fields changes from one row (record) to the next when reading a data set sequentially. I used to write RPG programs with control breaks often. Now that reports are less common, I write them less often, but that’s not to say I never write a program with control breaks.

  When I first learned to handle control breaks in RPG, I used the L1 through L9 level indicators. These worked wonderfully and fed my family for several years. When I moved from the System/36 world to the S/38 (and …

  Read more

• Guru: Calling RPG Programs From Python, Part 1

  March 30, 2020 Mike Larsen

  In a prior article, I showed how to pass parameters to a Python script and execute the script from an RPG program. Based on feedback and my own curiosity, I wanted to see how I could pass parameters to an RPG program and call it from Python. After a bit of research, I found the Python interface itoolkit.

  itoolkit is an open source project provided by IBM as an interface to the XMLSERVICE toolkit, which allows us to call RPG programs, service programs, CL programs, and PASE Shell commands. itoolkit can be installed using an SSH terminal with …

  Read more

• Guru: SQL Can Generate A Series

  March 16, 2020 Ted Holt

  Most of my work is run-of-the-mill, same-old-same-old, more-of-the-same. I’m not complaining. Most of life is mundane and routine, and that’s as it should be. Too much icing ruins the cake. But sometimes I get a challenge, and when that happens, programming can be fun.

  Today’s article comes out of such an experience. I needed a table with a week’s worth of dates in it. I could have written an RPG program, but I knew that SQL could handle the task. Today I’ll show you a couple of methods that you can use to generate a series of whole numbers and …

  Read more

• Thoroughly Modern: Giving IBM i Developers A Helping Hand

  March 9, 2020 Timothy Prickett Morgan

  The good thing about the Moore’s Law improvements in compute, storage, and networking capacity is that the cost of a complete IT system more accurately reflects where the real value of that system was always really derived.

  In decades gone by, the AS/400 hardware cost represented somewhere on the order of 85 percent of the cost of a server and its storage and the OS/400 systems software accounted for the remaining 15 percent or so. Over time, the hardware costs have dropped to about a third of the overall system cost as systems have also gotten incredibly more powerful. But …

  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

• Boadway’s 25-Year Performance Shows No Let Up

  March 2, 2020 Alex Woodie

  Batch jobs running a little long? Throw some hardware at it. For as long as Mike Boadway can remember, that’s been the default response to dealing with most performance issues on the IBM i server. But when today’s fast Power9 processors and Flash drives fail to move the performance needle, maybe it’s worth reconsidering Boadway’s approach to tweaking the code and the data instead.

  As the CEO of MB Software & Consulting, Boadway makes his living off solving other people’s IBM i performance issues. Since founding the company in 1995, Boadway has used his proprietary software to deliver an …

  Read more

Previous Articles Next Articles