• Guru: Qualified Files – Underused and Unappreciated

  September 14, 2020 Ted Holt

  When IBM adds a new feature to the RPG compiler, they do so for a reason. That’s why I try to learn new techniques. I hope they’ll improve the quality of the source code I write. One relatively new feature that I do not see widely used is the qualified file. In the following paragraphs, I’d like to tell you why I like qualified files and how to use them.

  To understand the need for qualified files, it may be good to begin with a brief lesson on the history of the RPG language. When RPG was originally developed, the …

  Read more

• A Guide To This Week’s Virtual POWERUp 2020

  September 14, 2020 Alex Woodie

  Sidelined by the COVID-19 epidemic, POWERUp 2020 takes flight today as a virtual conference. COMMON, which is celebrating its 60th birthday this year, has put together hundreds of sessions over the next four days to help its IBM i user base get the latest out of IBM technology. And with many sessions taking place live, there will be lots of chances to go one-on-one.

  In a typical year, POWERUp would be the biggest event on the IBM i schedule, a place to meet a thousand of your closest IBM i friends and get up-to-speed with the latest tech from IBM …

  Read more

• CNX Releases Beta of Valence 6.0

  September 2, 2020 Alex Woodie

  CNX last week announced the beta release of Valence 6.0, the newest version of its Web development framework and portal for IBM i. Valence 6.0 brings a whole new look and feel to Web applications created with Valence, as well as updates to administrative functions, the data access layer, and more.

  Valence is a set of tools for creating Web and mobile applications that run under IBM i’s Apache Web server and access existing RPG business logic. The product has several components, including a JavaScript library; a set of RPG procedures for integrating various JavaScript libraries (Ext JS, React, or …

  Read more

• Is It Time To Rename RPG?

  August 24, 2020 Alex Woodie

  Should IBM rename RPG, and if so, what should the new name be? It’s an interesting idea, and one that was recently floated by a member of the IBM i community, who submitted an official request for enhancement (RFE) on the matter. The crux of the argument is that full free-format RPG is such a dramatic departure from fixed-format RPG that it deserves a new name. But will IBM, which owns the language, go along with the change?

  Report Program Generator, or RPG, debuted way back in 1959, at the dawn of the computer age, as a way to replicate …

  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

• ARCAD Hooks Cross-Reference Tool into LPEX Editor

  August 19, 2020 Alex Woodie

  IBM i developers won’t have to leave the comfort of RDi and the LPEX editor to engage in application cross-referencing tasks, thanks to the recent integration between the ARCAD Observer cross-referencing software with LPEX.

  According to ARCAD Software, the new LPEX integration will bring “massive productivity benefits” to IBM i developers in the form of context-sensitive “where used” impact analysis, as well as dependency information, all delivered directly from within the LPEX editor.

  LPEX integration is a new feature delivered in late June in ARCAD Observer version 12.1. The company, which has offices in France, New Hampshire and Chicago …

  Read more

• Guru: Dynamic Arrays Come To RPG – The Next Part Of The Story

  August 17, 2020 Jon Paris

  In my first tip on this topic I covered the automatic sizing option (*AUTO) for the new dynamic arrays. In this tip I am going to look at the second option (*VAR), which allows the programmer to directly control the capacity of the array, growing and shrinking it as required. In addition I will also briefly cover the third option (*CTDTA) which, as you may have guessed, relates to compile time arrays.

  Using A Varying Length Array

  Let’s start with a brief example of using a variable sized array in conjunction with SQL. This approach answers the classic question of …

  Read more

• Thoroughly Modern: Strategic Things to Consider With APIs and IBM i

  August 10, 2020 Timothy Prickett Morgan

  The great thing about application programming interfaces is that many of the ways that programmers need to interact with system and application software are predefined and allow for consistent access to features and functions as well as data. To a certain extent, the APIs are what make such software useful. The API describes how the interface works, and libraries (in the sense of the software market at large, not the OS/400 and IBM i definition of that word) are developed to implement the functionality of the interface.

  The fun bit is that not only system software makers like IBM get …

  Read more

• Getting Out Of The Catch-22 Of Application Transformation

  August 3, 2020 Timothy Prickett Morgan

  If starting up a business is hard, maintaining that business can be even more difficult. Conditions and tastes change over time, and applications that drive the business can feel the strain.

  Upper management and IT organizations might have the skills to keep business applications going and make modest changes here and there, or perhaps add a new product line or two. But they usually do not have the time or people to do anything too radical, such as modernizing and transforming those applications to work in completely new ways. This is where bringing in a product and services partner comes …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

Previous Articles Next Articles