• Guru: LTRIM + RTRIM > TRIM

  April 2, 2018 Ted Holt

  When IBM enhances SQL for my favorite database management system, I feel so happy I could dance like Karlos Klaumannsmoller selling diabetes medicine. It is my pleasure today to let you know (in case you don’t already know) that IBM has once again enhanced two SQL functions to make them as powerful as their RPG counterparts.

  The functions to which I refer are LTRIM (left trim) and RTRIM (right trim). Until recently these functions could only remove blanks (or hexadecimal zeros, for some data types) from the beginning (left) or end (right) of a string. IBM recently added …

  Read more

• TEMBO Bolsters Database Modernization Kit

  March 26, 2018 Alex Woodie

  TEMBO Technology Lab is shipping a new release of its software designed to help IBM i shops modernize their databases for the SQL age. The South African company made mostly minor tweaks to its flagship product, dubbed AO Foundation, which should position the product to do more down the road.

  Since it entered the IBM i discussion in 2012, TEMBO has been building database modernization tools and evangelizing the benefits of the SQL Query Engine (SQE) as the modern, up-to-date database engine that IBM i shops should strive to use, as opposed to the older CQE engine that used DDS …

  Read more

• Rest4i Eyes Digital Transformation Via API

  March 21, 2018 Alex Woodie

  A new company headed by IBM i software veterans is beginning to turn some heads with a new product aimed at helping IBM i shops with digital transformation strategies. Rest4i, as the outfit is called, says its LXR framework turns IBM i into a lean, mean REST API-serving machine.

  Stuart Milligan, who headed the UK software firm Databorough before it was sold to Fresche Legacy (now Fresche Solutions) way back in 2013, says LXR (pronounced “Lexer”) is the result of four years of investment and development in a “pure IBM i REST API solution.”

  Milligan describes LXR as …

  Read more

• The IBM i Roadmap Leads To A Familiar Place

  March 19, 2018 Dan Burger

  Reeve Fritchman is working on project that he believes might tell the future of the IBM i. It’s a complex mainframe-to-IBM i migration. The core applications were written by an in-house team of developers, many who are still on the staff but on the verge of retirement. The hardware maintenance is expensive, and a hardware upgrade would be absurdly expensive. The bills from CA for automation software are staggering.

  “The demise of the mainframe in small to medium size shops could be a precursor of what will happen in the AS/400 environment – fewer skilled workers, expensive, and better technology …

  Read more

• Guru: Beyond The Basics Of Code Conversion

  March 19, 2018 Paul Tuohy

  Today many RPG programmers are tasked with having to modernize existing programs. These programs often have long and varied history. They may be RPG IV programs or they may be RPG IV programs that were originally RPG II or RPG III programs, or any permutation or combination you can imagine. There are tools available to help us convert from fixed-form RPG to free-form RPG and, within RDi, we have options to help us reformat code and refactor variable names. But these tools can only go so far. We finally reach the point where we have to put fingers to the …

  Read more

• A Code Inspector For RPG

  March 14, 2018 Alex Woodie

  Programmers who are tasked with maintaining applications often spend 50 percent or more of their time just figuring out how programs work, taking away valuable time they could spend on other tasks. Now a company called i400hub.com is promoting a new tool called RPG/Code Inspector that helps programmers reclaim that lost time.

  RPG/Code Inspector is a program comprehension tool created by longtime IBM i developer Steve Kilner that’s designed to help programmers discover what’s going on in their RPG applications quickly, without going line-by-line through the source code. The software automates several tasks for programmers, including:

  • Analyzing and cross-referencing how

  …

  Read more

• Guru: Use SQL To Find Duplicate Source Code

  March 12, 2018 Ted Holt

  According to Brian Tracy, “good habits are hard to develop but easy to live with; bad habits are easy to develop but hard to live with. The habits you have and the habits that have you will determine almost everything you achieve or fail to achieve.” This is as true in programming as in anything else we may do.

  Unfortunately, even those of us who strive for good work habits often have to follow the work of people who did not. One bad habit I come across occasionally is known in software engineering as WET solutions. WET stands for “write …

  Read more

• Advice For the IBM i Application Fence Sitters

  March 5, 2018 Dan Burger

  Most executive management does not recognize the importance of IT. They don’t understand it and, therefore, don’t see the potential business advantages that come with restructuring a system that was put in place 10, 20, or even 30 years ago. So, how important is it to influence the perception of IT within organizations?

  And how do you get more business managers thinking strategically about IT? One of the keys is to demonstrate how IT is the engine for growth and not a money pit with high risk and little return on investment. There are challenges to overcome, for sure. Don’t …

  Read more

• Guru: Moving A Web Service To Another Web Server

  February 19, 2018 Mike Larsen

  IBM Integrated Web Services (IWS) makes it easy to create web services and deploy them to a web server. If you need to deploy the same service to multiple web servers, you could use IWS to manually create it on each server, but it would be time-consuming and error-prone. Simply missing a setting when creating the service can lead to unexpected results.

  Or you could automate the process. That would ensure the attributes of the service carry forward from server to server. While I won’t get into the web service creation process, as there are already many articles that address …

  Read more

• New IBM i Technology Refreshes Announced; Available Mid-March

  February 14, 2018 Dan Burger

  IBM yesterday announced that Technology Refresh 8 (TR8) for IBM i 7.2 and TR4 for IBM i 7.3 will provide support for Power9 hardware, enhancements for RPG, security enhancements, and a variety of new capabilities for licensed products. The support for Power9 will be covered elsewhere in this issue of The Four Hundred. Here, we’ll provide an overview of the IBM i operating system, licensed programs, and software.

  When TR enhancements include RPG, I like to begin there. Application developers using Rational Development Studio should take note of the new operation code referred to as DATA-INTO, which adds the …

  Read more

Previous Articles Next Articles