• Altova Updates Db2 for i Support Across Product Line

  July 14, 2021 Alex Woodie

  IBM i shops that use data and development tools from Altova will be happy to know that the software vendor has added support for the latest release of Db2 for i among several of its tools.

  Altova is a Beverley, Massachusetts, company that develops a series of software tools and utilities for developers. The company is arguably best known as the creator of XMLSpy, an IDE that allows developers to create XML-based Web services using standards like WSDL; it later added support for JSON data and the modern SOAP protocol.

  In 2010, Altova added support for IBM i in MissionKit, …

  Read more

• So You Want To Do Containerized Microservices In the Cloud?

  June 30, 2021 Alex Woodie

  As a modernization consultant working in IBM’s Rochester, Minnesota, lab, Amy Anderson gets to hear from some of the most tech-savvy IBM i shops in the world. Her job requires her to know where shops are now, listen to where they want to go, and chart a path that takes them there. That can sometimes be quite a challenge, especially considering the rapid pace of technological change at the moment.

  “One of the things that we’re seeing now is the whole industry now is focused on modernization,” Anderson said during her session at the recent NAViGATE conference hosted by COMMON …

  Read more

• Modern Tools For A Modern IBM i

  May 26, 2021 Alex Woodie

  IBM i shops may be in for a rude awakening when they suddenly realize their applications are not keeping up with the times. How can these IBM i shops get on the right track in the modernization department? A trio of IBMers offered some tips.

  Brad Bentley, Tim Rowe, and Kris Whitney took to the virtual airwaves last week to present “IBM Tools for Modernizing Your IBM i Applications,” a one-hour webinar from IBM. Application modernization is an extremely broad topic, as the 266-page IBM Redbook of the (almost) same name will attest to, so they obviously didn’t cover …

  Read more

• Guru: Fall Brings New RPG Features, Part 3

  January 18, 2021 Jon Paris

  In my previous tips (see Related Stories below), I covered the new BIFs and op-code options added with this release. This time I’m going to discuss a couple of new compiler options that focus on the conversion of character data to numeric.

  While you may not have needed these capabilities to date, it is highly likely that you will in the near future. Why? Because of the rapid growth in the use of web services in the IBM i world. I don’t think I have talked to a single client in the last 12 months who was not already providing …

  Read more

• Guru: Fall Brings New RPG Features, Part 2

  January 11, 2021 Jon Paris

  In my previous tip I outlined some of the new features added to RPG with the Fall 2020 release. In this and the following tip I will be covering the features that I ran out of space for in that first one.

  This time I will cover the new FOR-EACH loop construct. I have wanted this in RPG ever since encountering it in PHP. Simply put, it automatically iterates through an array, “serving up” one element at a time. When I say “an array” I mean any kind of array, including data structure arrays, dynamic arrays and even the new …

  Read more

• Remain Software Delivers Trio of Updates

  November 11, 2020 Alex Woodie

  Remain Software last week announced the delivery of new releases of three separate products, including TD/OMS, its lifecycle management tools for IBM i; Gravity, its workflow management system for multiple systems; API Studio, which helps IBM i shops develop and manage API connections to existing software.

  TD/OMS, which is Remain Software’s flagship offering, is an application lifecycle management (ALM) tool for IBM i developers. The core of the offering is the Object Management System (OMS), which guides users through the process of defining applications and their associated objects, while additional modules provide more targeted functionality for reporting, impact analysis, …

  Read more

• IBM Brings More Open Source to IBM i

  October 14, 2020 Alex Woodie

  IBM has brought an array of new open source packages to its IBM i operating system with the latest batch of Technology Refreshes, including tools for application developers and systems administrators. It’s all part of IBM’s strategy to keep IBM i on the cutting edge through open source, says IBM’s business architect Jesse Gorzinski.

  Before IBM unveiled IBM i 7.4 TR3 and 7.3 TR9 last week, we’d already written extensively about many the open source package that IBM has brought to the platform. For instance, we told you earlier this year how Apache Kafka and Apache Zookeeper were running on …

  Read more

• Guru: Reading Nested XML Using SQL

  August 31, 2020 Jonathan M. Heinz

  XML is a data-interchange format, not a relational database management system. For this reason, using SQL to query XML data can be challenging, as what would be stored in two relational tables are placed in one element of XML. To put it another way, detail data is nested under the header data.

  I would like to share a way of using SQL to extract nested data from an XML file. I found this method useful when testing a change to a process that creates XML to be sent to customers. I can use this SQL to quickly check that the …

  Read more

• i2Rest Offers Native API Alternative to IWS

  August 19, 2020 Alex Woodie

  IBM i shops that want to expose their RPG applications as industry standard Web services have a few options to choose from. One solution they should keep on their list is i2Rest, which is a native ILE application that exposes RPG using modern OAuth2 and OpenAPI standards.

  We first came across Alexei Baranov’s work back in 2012, when he was involved in the port of the SVN client to IBM i while working at a Moscow, Russia-based consulting firm. Soon thereafter, Baranov started working on developing Web services tools for IBM i.

  The first version of his new Web …

  Read more

• IBMiUnit Moves RPG Unit Testing Forward

  June 24, 2020 Alex Woodie

  As IBM i shops break up their monolithic programs into more reusable chunks, it’s reasonable to assume that they would adopt unit testing to make sure those chunks are working properly before promoting them into production. Unit testing hasn’t been widely adopted on the IBM i platform, which is why RPG developers who are looking for a unit testing tool may be interested in a new framework called IBMiUnit.

  IBMiUnit is an open source project that helps programmers test any RPG-based program, subprocedure, or method, including RPG-based SQL. The software, which is modeled off the popular JUnit and xUnit frameworks, …

  Read more

Previous Articles