• Guru: A Simple, Effective Way To Compare Data Using SQL

  April 20, 2020 Ted Holt

  One thing I have learned over the years is that no matter how much technology changes, people always ask the same questions like: “Why does the computer say we have 50 widgets when we only have 45?” and “Can you tell me who changed the due date of order number 12345?” and “How do sales of widgets this year compare to the same time last year?” It is the last of these that I wish to address today.

  Comparing data is a very common activity. Everybody compares data: sales people, production people, purchasing people, and of course management people. This …

  Read more

• Here’s What’s In the Latest IBM i Technology Refreshes

  April 15, 2020 Alex Woodie

  As expected, IBM today officially unveiled its spring Technology Refreshes for IBM i. Among the goodies that will become available for IBM i 7.4 TR2 or IBM i 7.3 TR8 (or both) are enhancements to Db2 Mirror, a new approach to tape library virtualization, improvements to open source, and new features and functionality around Db2, RPG, RDi, and security, too.

  Months ago, IBM execs circled April 14 on their calendars as the day for the big IBM 7.4 TR2 and IBM i 7.3 TR8 reveal, with the idea that the following week’s POWERUp conference in Atlanta, Georgia (now canceled, but …

  Read more

• Guru: Copy From Stream File FMTOPT(*NOCHK)

  April 13, 2020 Bob Cozzi

  Using SQL frequently, as I do, I tend to look for solutions to problems that can be resolved using the database language (i.e., SQL). Sometimes I have to invent a missing piece of the puzzle. Often that entails writing a User-Defined Function (UDF) for use in SQL, but sometimes a CL command is the better choice.

  Recently I had a situation where what the client calls an “EDI File” was being downloaded using sftp on the IBM server running i. This file is created at a vendor that runs IBM mainframes (an actual mainframe by the way) and the file …

  Read more

• Guru: SQL Checks For Control Breaks

  April 6, 2020 Ted Holt

  A control break occurs when the combined value of one or more fields changes from one row (record) to the next when reading a data set sequentially. I used to write RPG programs with control breaks often. Now that reports are less common, I write them less often, but that’s not to say I never write a program with control breaks.

  When I first learned to handle control breaks in RPG, I used the L1 through L9 level indicators. These worked wonderfully and fed my family for several years. When I moved from the System/36 world to the S/38 (and …

  Read more

• Guru: SQL Can Generate A Series

  March 16, 2020 Ted Holt

  Most of my work is run-of-the-mill, same-old-same-old, more-of-the-same. I’m not complaining. Most of life is mundane and routine, and that’s as it should be. Too much icing ruins the cake. But sometimes I get a challenge, and when that happens, programming can be fun.

  Today’s article comes out of such an experience. I needed a table with a week’s worth of dates in it. I could have written an RPG program, but I knew that SQL could handle the task. Today I’ll show you a couple of methods that you can use to generate a series of whole numbers and …

  Read more

• Analytics Moves To The Cloud, And IBM i Data Goes With It

  March 11, 2020 Alex Woodie

  The cloud is changing the face of IT, much to the chagrin of IBM i traditionalists who are accustomed to having full control over their applications and data. Change is always hard, but the good news is that, with a little discipline, the cloud presents a number of new and exciting analytical options for your important IBM i data.

  As a transaction processing powerhouse, the IBM i server is accustomed to hosting the most important data a business ever touches, including data about customers and their purchases. On-prem servers still run the lion’s share of online transactional processing (OLTP) workloads, …

  Read more

• What’s New with RDi Version 9.6.0.7

  March 11, 2020 Alex Woodie

  IBM last month unveiled Rational Developer for i (RDi) version 9.6.0.7, the first release of the popular IBM i development environment in about a year. With this release, IBM is giving developers a handful of new capabilities, including the ability to create procedures out of pieces of code, as well as the ability to test incoming parameters.

  RDi is IBM’s flagship integrated development environment (IDE) for the IBM i platform. The product isn’t universally used across the IBM i community, and it’s not free. But many IBM i professionals swear by the graphical and modern IDE, particularly compared to older …

  Read more

• Guru Classic: Tuning SQL Environments On i

  March 4, 2020 Paul Tuohy

  Author’s Note: This article was originally published in November 2015. This was one of the first DB2 for i Services that I used in anger. I have used a lot since.

  One of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that piques your interest, it invariably clashes with when you are speaking. But every now and again, the scheduling gods work in your favor. Such was the case when I spoke at the excellent International i-Power 2015 conference at Wyboston Lakes Executive Centre in the UK. …

  Read more

• Boadway’s 25-Year Performance Shows No Let Up

  March 2, 2020 Alex Woodie

  Batch jobs running a little long? Throw some hardware at it. For as long as Mike Boadway can remember, that’s been the default response to dealing with most performance issues on the IBM i server. But when today’s fast Power9 processors and Flash drives fail to move the performance needle, maybe it’s worth reconsidering Boadway’s approach to tweaking the code and the data instead.

  As the CEO of MB Software & Consulting, Boadway makes his living off solving other people’s IBM i performance issues. Since founding the company in 1995, Boadway has used his proprietary software to deliver an …

  Read more

• The Gamification Of Good Coding Practices

  February 26, 2020 Nick Blamey

  There are many things that are important about creating good code, but perhaps the most important is the idea that there are good coding practices and that everyone coding, no matter what the programming language and no matter what the type of application they are creating, should adhere to some standards of quality.

  It is often the case that those have spent decades automating different aspects of businesses with systems like the IBM i and its peers have been the most resistant to brining automation to the very work they do in development and operations. But if the DevOps movement …

  Read more

Previous Articles Next Articles