• 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

• 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

• Scaling Up For Cyber Monday With IBM i

  November 26, 2018 Alex Woodie

  A fulfillment company that’s expected to process millions of transactions on an IBM i server today will lean heavily on a slim layer of RPG-based Web services technology to keep the commerce flowing for its large clients. But there’s nothing stopping the middleware, dubbed iWebSrv, from simplifying data integration for clients in other industries.

  Retailers work all year to ensure they’re ready for the massive surge of traffic that springs up after Thanksgiving. For bricks-and-mortar types, Black Friday is their make-or-break day, while those with an omni-channel bent have Cyber Monday prominently circled on their calendars.

  Consumers are expected to …

  Read more

• Modernizing IBM i Apps with Microservices

  November 7, 2018 Alex Woodie

  Application modernization means different things to different people. For some, it could be turning a 5250 screen into a Web or mobile interface, or replacing database access with SQL. But for others in the IBM i community, including the vendor OpenLegacy, modernization refers to exposing existing business logic as APIs through a microservices architecture.

  Microservices refers to a software development technique whereby applications are broken down into multiple self-contained components and served via APIs in a loosely coupled but coordinated manner. The main advantage of this approach is each microservice is built independently of others, which can boost productivity and …

  Read more

• Infor Elaborates on Coleman, IBM i Strategy

  October 10, 2018 Alex Woodie

  When Infor held its annual Inforum conference two weeks ago, the new AI bot Coleman played a big part, but nary an IBM i word was muttered publically. But that shouldn’t come as a concern to the thousands of companies that rely on the company’s IBM i software to run their businesses, Infor’s IBM i strategy Ross Freeman leader says.

  “We heard the same from Syteline customers. They didn’t hear much about Syteline,” says Freeman, who heads up IBM i strategy for the LX, XA, and System 21 ERP product lines. “We have 235 products and we’re all following the …

  Read more

Previous Articles