• 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

• 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

• Guru: SQL Functions Can Do Non-function Things

  January 27, 2020 Ted Holt

  We all know that the SQL SELECT statement only retrieves data, right? If you want to modify data, you have to use INSERT, UPDATE, DELETE, or MERGE, correct? Well, to quote the great George Gershwin, It Ain’t Necessarily So. You can modify data from a SELECT statement, and maybe sometimes you should. Here’s how it’s done.

  I’ll illustrate with a SELECT statement that will run the Reorganize Physical File (RGZPFM) command over physical files that have at least 10 percent deleted records. I could do this with plain ol’ CL, of course, and that’s probably the approach I would …

  Read more

• Industry Speaks: IBM i Predictions for 2020, Part 1

  January 20, 2020 Alex Woodie

  We are three weeks into 2020, and that New Year smell hasn’t worn off yet. As time rolls on, the IBM i community will certainly get down to business. In the meantime, here are industry predictions from nine community members to read.

  For Alan Seiden, the CEO of Seiden Group and an IBM Champion for Power, risk management will be a common theme for how they approach IT staffing in 2020.

  “IBM i shops have traditionally operated in a lean manner, relying on key individuals who knew their systems intimately,” Seiden says. “Now, with IT staff managing more projects than …

  Read more

• Update On Migration Of developerWorks Content

  January 15, 2020 Alex Woodie

  On New Year’s Day, IBM fulfilled its promise to turn off the developerWorks Connections website, which hosted technical content posted by members of the IBM i community. But before it hit the “delete” button, Big Blue worked with content owners to migrate the most active content to other websites, to redirect browser traffic, and to archive the rest.

  IBM made good on its previous promise to ensure that no content was left behind when it permanently shuttered the popular developerWorks Connections website. It was forced to make that promise after it caused an uproar in October, when it announced that …

  Read more

Previous Articles Next Articles