New Solution for Combining Multiple Row Values into a Single Row with SQL
The LISTAGG function makes combining row values easier.
By Kent Milligan
Several years have passed since I wrote articles on how to use the Db2 for i Connect By and Recursive Common Table Expression features to combine multiple row values into a single row. The following table represents the type of report that could be generated using the SQL detailed in those articles.
Why /Free in RPG?
Why should you use /Free? Certainly positional RPG is familiar to everyone in our world. Why bother to learn or use /Free? Fortunately, there are a ton of articles out there about the advantages of /Free, so I am not going to belabor it. Just search on “RPG Free advantages”.
By David Shirey
Editor’s Note: This article is excerpted from chapter 3 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey.
The thrust of /Free is simple: it gives you opcodes and structures that do not have to be in a given column position on the screen. And this allows you to do four things.
Four Hundred Monitor, May 5 – IT Jungle
Four Hundred Monitor, May 5 IT Jungle