• 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

• How Infor’s Coleman Strategy Is Evolving, and How IBM i Fits In

  November 20, 2019 Alex Woodie

  It’s been more than two years since Infor unveiled Coleman, the company’s AI platform which became generally available earlier this year. It’s not on the roadmap for IBM i just yet, according to Infor. That may not sound ideal for Infor’s IBM i customers, but it’s not necessarily a bad thing.

  Coleman was unveiled by ERP software giant Infor in 2017 primarily as a digital assistant, which is a fancy way of saying a chatbot. Just as Siri and Alexa can answer questions about the weather or sports, Coleman could answer basic questions about the business, and even handle some …

  Read more

• Digging Into the Latest IBM i TRs

  October 23, 2019 Alex Woodie

  The fall batch of Technology Refreshes (TRs) have been revealed, and as expected, there’s a bit of new functionality available for customers who use IBM i 7.3 and 7.4. In this story, we’ll tackle enhancements in open source, systems management and monitoring, and development, which means we’ll dive deeper into other areas, like database and HA/DR, in a future story.

  Let’s start with the fun stuff: open source. With IBM i 7.3 TR7 and 7.4 TR1, IBM has brought support for two prominent open source projects, including ZeroMQ and Redis.

  ZeroMQ is a universal messaging library that allows users to …

  Read more

• IBM i 7.3 And 7.4 Get Their Autumn Tech Refreshes

  October 9, 2019 Timothy Prickett Morgan

  Big Blue is hosting its IBM Systems Technical University this week, and used the occasion to quietly launch the Technology Refreshes, or TRs as they are known, for IBM i releases 7.3 and 7.4. If you were running around the Venetian Hotel, you could probably stitch together the extent of the updates to the platform, and to be honest, we are still trying to get all of the details, which were not available as we went to press.

  We will tell you what we know now, and then circle back and drill down into the details as appropriate.

  First of …

  Read more

• Boutique Footwear Company Finds A Great Fit With Node.js

  August 19, 2019 Alex Woodie

  As one of the premier providers of winter footwear in North America and Europe, Kamik knows what it takes to run a successful manufacturing operation. But when its custom RPG-based ERP system started to show its age, the company turned to Node.js to help modernize production systems, and found that it improved application integration and developer productivity along the way.

  “Legacy” is a word that the folks at Kamik can take pride in. Founded in Quebec in 1898, Kamik remains a family owned business to this day, with factories located in Canada and the United States. Through its brand-name and …

  Read more

• Guru Classic: The Efficiency of Varying Length Character Variables

  August 14, 2019 Jon Paris

  Remember the bad old days when dinosaurs still roamed the earth and the only way to build strings in RPG involved playing silly games with arrays? Or worse still, obscure combinations of MOVE operations? Thankfully those days are far behind us — although sadly there are still a few RPG/400 dinosaurs coding away!

  RPG IV introduced many powerful new string handling options, such as the %TRIMx family of BIFs, but even now there are capabilities in the language that few programmers fully exploit. One of my favorites is variable length fields. This lack of familiarity made this tip an obvious …

  Read more

• Remain Breaks New Ground With ALM Suite

  July 15, 2019 Alex Woodie

  Coding season just ended for Remain Software, the Dutch application lifecycle management (ALM) vendor with a growing US presence. That means customers are sorting through a torrent of new functionality in its flagship TD/OMS product, including improved hooks to DevOps tools like Git and Jenkins, a new cross-platform cross-reference module, and a nifty API generator too.

  New stuff started emerging from Remain Software around the POWERUp conference in May, when IT Jungle sat down with company representatives to talk about development trends, current and upcoming releases of Remain’s software, and what customers are looking to get next.

  Arguably the biggest …

  Read more

• Guru Classic: Where Does Data Live? The New Basics

  June 19, 2019 Jon Paris

  Every time I teach some of the more recent additions to RPG, such as XML parsing or Open Access, I find that I need to include some “remedial” education on some of the data definition enhancements that have been made to the language over recent releases.

  Most of these enhancements came into the language many years ago back in the days when D-specs were de rigueur, but if you had no immediate need for them, they may have passed you by. After all, even the most avid reader of this newsletter has probably forgotten most of what they read here …

  Read more

• A HATS For Many Occasions

  March 25, 2019 Alex Woodie

  IBM gives customers plenty of options when it comes to its Rational Host Access Transformation software, including several modes of operation, different runtime options, and support for different operating systems in screen modernization engagements. With last week’s launch of HATS version 9.7, the development and deployment options got even wider.

  Regardless of which downstream options a HATS customer ultimately chooses, it all starts out basically the same on the front side of the sausage machine: Customers come to HATS because they have a 5250 (or 3270 or VT100) application that they want to transform, but they don’t want to go …

  Read more

• Guru: When Playing With SQL

  March 18, 2019 Paul Tuohy

  One of the questions I have been asked a lot at conferences is “How do you figure out x in SQL?” In this article, I will discuss four things I use a lot when playing with SQL in Run SQL Scripts: VALUES, SYSIBM.SYSDUMMY1, global variables, and the system catalog.

  VALUES

  When I am trying to figure out how an SQL function works, my first port of call is the VALUES statement. VALUES derives a result directly from an expression. For example, the following statement:

  values upper('paul');
  

  Would generate the following result set:

  

  You can specify more than one value in …

  Read more

Previous Articles