• 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

• More Open Source Databases Coming To IBM i

  June 15, 2020 Alex Woodie

  IBM is in the process of bringing several new open source databases to the IBM i platform, including schema-less NoSQL databases as well traditional relational systems. Among the databases that Rochester is targeting are MongoDB, arguably the most popular NoSQL database and a favorite among Web and mobile developers, as well as PostgreSQL, one of the industry’s oldest and most widely used relational databases.

  Databases today almost are like programming languages, with developers mixing and matching databases to handle different functions, often within the same application. DB-Engines.com tracks more than 330 distinct databases, while there are somewhere around 700 programming …

  Read more

• The End is Near for Zend Server Basic PHP

  May 20, 2020 Alex Woodie

  Zend Server Basic, the free PHP runtime used by thousands of IBM i shops, will cease being offered starting in July 2021. That’s the word from Perforce, the company that now owns Zend and its lineup of PHP tools and technologies. The replacement, of course, is the new community edition of PHP that became available via RPM in late 2019.

  Starting in 2006, Zend Technology began to develop a special version of its PHP runtime for IBM i, which was then called i5/OS. This offering, dubbed Zend Core for i5/OS, provided a familiar way for users of the iSeries server …

  Read more

• 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

Previous Articles