• VS Code Provides Another Coding Option for IBM i

  December 9, 2020 Alex Woodie

  IBM i shops that are looking for an alternative to IBM’s Rational Developer for IBM i (RDi) may want to check out a lightweight code editor from Microsoft called Visual Studio Code (VS Code). Thanks to extensions for IBM i languages developed by the opensource community, VS Code can support native development in RPG, CL, and SQL.

  First released by Microsoft in 2015, VS Code provides a basic environment for writing and editing code. It features debugging, syntax highlighting, intelligent code completion, snippets, and code refactoring, as well as embedded Git. It runs on Windows, Linux, and Mac, and while …

  Read more

• Open Source The Path To Software Riches For IBM i

  December 2, 2020 Alex Woodie

  For what is supposed to be a proprietary platform, the IBM i server sure has a lot of open source software running on it. In recent months, it appears that the majority of new programs introduced to IBM i are open source in nature. That pattern shows no signs of changing any time soon, according to a recent report by OpenLogic.

  Open software has existed on the IBM i platform for many years. The first highly publicized dip into the open source well occurred in 2005, when IBM partnered with a company called Zend to bring its PHP runtime to …

  Read more

• Guru: SQL Writes CL

  November 30, 2020 Ted Holt

  SQL is the one tool I cannot work without. Take it away from me and I’ll start driving a truck for a living. Naturally I’m eager to find more ways to make SQL work for me. Today I’d like to share how I recently used SQL to write a huge CL command for me. This is a technique that’s good to know.

  My challenge was to copy all of the several hundred physical data files in a library to a save file so that those files could be loaded onto another IBM i system. The Save Library (SAVLIB) command was …

  Read more

• How The Latest TRs Bolster The Core IBM i OS

  October 7, 2020 Alex Woodie

  Yesterday was Technology Refresh (TR) day for IBM and its IBM i operating system, and Big Blue didn’t disappoint. The company unveiled new releases of IBM i 7.4 and 7.3 that bring a slew of new capabilities to the core operating system as well as surrounding offerings like Db2 Mirror, ACS, and RDi. In this article, we’ll look at enhancements to the core OS and related key features.

  During a COMMON webcast Tuesday, IBM i Chief Architect Steve Will touched broadly on a number of enhancements that soon will be available in the TRs. Most of the new capabilities will …

  Read more

• Jenkins Gets Closer IBM i Hooks, Courtesy Of ARCAD

  September 14, 2020 Alex Woodie

  For some time, IBM i shops have been behind the curve when it comes to using modern DevOps and continuous integration/continuous delivery (CI/CD) technologies and techniques. ARCAD Software has been working to close that gap through its work with Git and Jenkins, and thanks to its new integration with an enterprise version of Jenkins from CloudBees, the gap is pretty much closed — at least from a technology point of view.

  Jenkins, if you don’t know yet, is a popular open source project that allows DevOps professionals to build, test, and deploy their software as part of a CI/CD …

  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

• New Option Emerges for Refactoring IBM i Apps

  August 19, 2020 Alex Woodie

  IBM i shops that want to refactor their RPG and COBOL applications into different languages have a new option available to them. In late June, Astadia and Blu Age announced they’re working together on a new service that automates the conversion of customers’ older apps into Java and .NET code that can run on X86 systems in your basement or the cloud.

  Based in Boston, Massachusetts, Astadia claims to have completed more than 200 mainframe migrations and more than 100 mainframe modernization projects over about two-and-a-half decades. The company has modernized millions of lines of COBOL code running on mainframes …

  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

• Red Hat’s Ansible Automation Comes To IBM i

  August 3, 2020 Alex Woodie

  Big Blue is now supporting IBM i with Ansible, the open source configuration management software developed by Red Hat. By including IBM i and AIX as a supported target in Ansible, companies that run IBM i will be able to remotely configure and manage IBM i and AIX servers using the same Ansible tools and techniques that they use to manage mainstream X86 and cloud server environments.

  Ansible was created back in 2012 by Michael DeHaan, the author of the Cobbler provisioning server and co-author of the Fedora Unified Network Controller (Func) framework for remote administration. It’s been widely adopted …

  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