• 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

  (Sponsored Content) 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 …

  Read more

• Guru: Alternate SQL Row-Selection Criteria Revisited

  February 24, 2020 Ted Holt

  At the RPG & DB2 Summit last October, I chanced to overhear Rob Bestgen of IBM telling Paul Tuohy of System i Developer about a practice that he and others in IBM Lab Services had seen, a practice which they found horrifying. “Oh, no!” I thought. “I’ve written about that for itjungle.com!” Are you ready to be horrified?

  Rob was telling Paul that they have seen SQL queries in which portions of the WHERE clause are enabled or disabled through the use of switches. I did not invent this technique — I realized more than a few years ago that …

  Read more

• Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL!

  February 10, 2020 Birgitta Hauser

  STRSQL, the green-screen facility for executing SQL Statements, has had its days. Nevertheless, many SQL users still prefer this legacy interface over the Access Client Solutions (ACS) Run SQL Scripts facility. Others use third-party tools to execute SQL statements. The common excuse has been that the Run SQL Script facility does not include a way to prompt SQL commands, tables, and columns. In ACS version 1.1.8.3, Content Assist includes prompting for SQL statements.

  Before ACS Version 1.1.8.3, no prompting was available within the Run SQL Scripts Facility. To access tables, views or materialized query tables (MQTs), we needed to know …

  Read more

• Guru Classic: Find a View of a View of a View. . .

  February 5, 2020 Paul Tuohy

  Author’s Note: This article was originally published in October 2014. This stored procedure is something I use a lot and has saved me from accidentally deleting dependent views more than once. Basically, I call it before I ever drop a view.

  SQLs Data Definition Language (DDL) offers many great features, one of which is the ability to define a view of a view. This can lead to simple or complex structures making use of views of views of views of . . . you get the idea.

  But one of the difficulties with this technique is that, once created, it …

  Read more

• Guru: Copy OUTQ To PDF

  February 3, 2020 Bob Cozzi

  A long time ago I created a CL command named Copy from OUTQ (CPYOUTQ). This command allowed you to selectively copy spooled files from one OUTQ to either another OUTQ or to the IFS as a PDF or text file. My customers use it all the time for monthly archiving of spooled files and redistribution of output. You may have it on your own system.

  Being one of the handful of original advocates for the so called “Openness APIs” for IBM OS/400 (now IBM i), I quickly embraced the system APIs and have used them extensively throughout the decades. One …

  Read more

Previous Articles