• Cloud ERP for Less than $400 Per Month? Now There’s a Concept

  July 22, 2019 Alex Woodie

  What do you call a full-fledged ERP system running on a private IBM i cloud that costs less than $400 per month for three users? If you’re Software Concepts – the Massachusetts-based ERP vendor behind the bold new deal – you might call it just what the IBM i ecosystem needed.

  The IBM midrange server has always been something of an enigma in the IT business. Tucked between the giant mainframes running Fortune 100 outfits and the PCs favored by one-man shops, the AS/400 and its progeny have catered to midsized organizations that demand advanced business functionality, but not the …

  Read more

• Guru Classic: My Favorite Keyboard Shortcuts for RSE/RDi

  July 17, 2019 Susan Gantner

  When using RDi for editing my CL, DDS, RPG, or COBOL code, I find that I can save a lot of time by using keyboard shortcuts for functions that would otherwise require that I take my hands off the keyboard to use the mouse. So I thought I would share a few of my favorites. Many of the shortcuts I use are standard for other applications that I also use for email, spreadsheets or text editing. It’s easy to forget that some of those same shortcuts can be used when we’re editing our RPG code.

  A lot has changed on …

  Read more

• Guru Classic: The New Basics — Indicators

  July 17, 2019 Jon Paris

  The history of indicators pre-dates even the earliest versions of RPG and takes us all the way back to the old tabulating machines, perhaps even earlier depending on how broad a definition one uses. What is without doubt, though, is that indicators in the sense of *INnn and *INLR were added to the RPG language as a vehicle for translating those old tabulator board programs.

  RPG has grown a lot since those early days, and yet many people still write code using the old-style numbered indicators. LR? Well, we’re kind of stuck with that, but there hasn’t been a need …

  Read more

• Guru Classic: Looking For Commitment, Part 2

  July 17, 2019 Paul Tuohy

  As companies look to modernize their applications, commitment control can play an integral role. This set of three articles was originally published in March 2009. The content of the articles has been updated for free form RPG.

  In this article I will take a look at the basic rules and coding requirements for using commitment control within RPG programs.

  A Database

  This is the SQL used to create a schema named COMMIT, which contains two related tables called HEADER and DETAILS.

  (A)  CREATE SCHEMA "COMMIT" ;
  
  (B)  CREATE TABLE COMMIT/HEADER (
       	"KEY" CHAR(2) CCSID 37 NOT NULL DEFAULT '' ,
       	

  …

  Read more

• Remain Breaks New Ground With ALM Suite

  July 15, 2019 Alex Woodie

  Coding season just ended for Remain Software, the Dutch application lifecycle management (ALM) vendor with a growing US presence. That means customers are sorting through a torrent of new functionality in its flagship TD/OMS product, including improved hooks to DevOps tools like Git and Jenkins, a new cross-platform cross-reference module, and a nifty API generator too.

  New stuff started emerging from Remain Software around the POWERUp conference in May, when IT Jungle sat down with company representatives to talk about development trends, current and upcoming releases of Remain’s software, and what customers are looking to get next.

  Arguably the biggest …

  Read more

• Guru: Finding Large Files With Python

  July 15, 2019 Mike Larsen

  It’s always a good idea to purge files that aren’t needed any longer. Chances are that you already have procedures in place to purge data from Db2 files and tables, but what about files that reside in the IFS? Do you have a good solution for keeping the IFS clean?

  Perhaps you have old order files stored in the IFS. If you work for a large company, these types of files can accumulate quickly. I’ve written processes in the past to remove files from the IFS using RPG, but I’d like to offer an alternative. I’m going to show how …

  Read more

• Eradani Bridges The Gap Between Legacy And Open Source

  July 8, 2019 Timothy Prickett Morgan

  In this publication, legacy is not a dirty word or even remotely pejorative. Rather, “legacy” is just a shorthand way of delineating between applications that encapsulate decades of the evolution of a business and the transactions it processes, and all of the other new stuff that this business is also doing and perhaps coding with newer tools and programming languages.

  A new company, called Eradani, has been founded by some experts in both the IBM i world and the open source world with the express purpose of building a technical bridge so these two different cultures can see a …

  Read more

• Guru: One Way To Deal With Two Null Formats

  July 8, 2019 Ted Holt

  Hey, Ted:

  We are building a new system and want to use modern programming and database techniques. I have had quite a time trying to get nulls to act right. It gets confusing fast because RPG handles them differently than the way embedded SQL does. When using SQL for I/O, how do we handle the two null formats?

  — Brian

  There are several ways to go about the “problem” of nulls. Let me give you one simple method, but keep in mind that it’s not the only way.

  First, let’s create a table and put some data into it.

  create 

  …

  Read more

• ARCAD Brings Traditional 5250 Development Into DevOps Fold

  June 24, 2019 Alex Woodie

  IBM i developers who embrace modern DevOps techniques typically also use modern development tools, like RDi. Much of the IBM i world uses IBM’s latest development environment, but many have resisted. Now, thanks to new software from ARCAD Software, IBM i developers who work with older tools like PDM can also partake of the benefits of DevOps.

  Getting older IBM i developers on board with the latest tools and techniques is a big priority for ARCAD Software, according to Alexandre Codinach, vice president of Americas for ARCAD Software, which included the new 5250 development capabilities with the launch of …

  Read more

• Guru: When %SCAN Isn’t Sufficient

  June 24, 2019 Ted Holt

  The RPG %SCAN built-in function is wonderful! I can still remember having to look for a string within a string using RPG II on System/36. What an ordeal that was! Yet in some situations %SCAN can’t do all I need it to do. In those cases, I rely on the power of SQL.

  One case where SQL comes in handy is when I need a case-insensitive scan. Instead of RPG’s %SCAN function, I use SQL’s LOCATE and UPPER functions, like this:

  dcl-s  Description  char(48);
  dcl-s  pos          int (10);
  
  exec sql
     set :pos = locate ('HAMMER', upper(:Description));
  

  If Description has the …

  Read more

Previous Articles