• Guru: Retrieving The Long And Short Object Name

  August 14, 2023 Bob Cozzi

  Many releases ago, IBM i received “Long SQL Names” for files and libraries. These new longer names (up to 128 characters) were well received by SQL enthusiasts, but largely ignored by the mainstream IBM i developer. As each version of IBM i emerged, more and more shops experienced one or more objects with a longer-than-10-character name.

  Recently I created a file named BOAT_TRAFFIC. This name is clearly longer than 10 characters. I used SQL DDL (the CREATE or REPLACE TABLE statement) to create the file. Using SQL DDL is the only real way to create an object with a long …

  Read more

• Guru: Binding Directory Entries

  June 5, 2023 Bob Cozzi

  I assume you’ve heard about *BNDDIR (Binding Directory) objects introduced circa 1994 with OS/400 V3R2. The infamous QC2LE binding directory is used by a huge number of RPG applications to access C runtime and unblocked MI functions such as system cvthc, cpybytes, and matmatr. You have probably seen RPG IV source code with the BNDDIR(‘QC2LE’) keyword on the header specification.

  I was one of the first developers outside of IBM to use Binding Directories for my own code. When I go back and look at my own RPG IV code created prior to mid-2007, well over 90 percent of it …

  Read more

• A Frank Solstice

  June 20, 2022 Timothy Prickett Morgan

  When you are born in Minnesota, the seasons matter. Unfortunately, as Frank Soltis, the former chief architect of the AS/400 system and the creator of the single-level storage architecture of the System/38 and the AS/400 that is still a marvel, once quipped to us: “There are only two seasons in Minnesota: Winter, and Getting Ready For Winter.”

  And so, you have two options: Play hockey when you aren’t farming, or design excellent computer systems. That’s how supercomputer genius Seymour Cray did it from nearby Wisconsin.

  The AS/400 for which this publication was founded 33 years ago was born on the …

  Read more

• The State Of The IBM i Base 2022: Third Party Software Conundrum

  April 11, 2022 Timothy Prickett Morgan

  Aside from death, most problems are not intractable. But people surely can be, and sometimes are. But luckily not often, and the thing about people is that, generally speaking, they can be reasonable when they are reasoned with. It is with all of this in mind that we come to the next in the State of IBM i Base stories for 2022, where we want to talk about the software trap that the remaining OS/400, i5/OS, and some IBM i shops have gotten themselves into and how we might help them get out of it to the mutual benefit of …

  Read more

• Reader Feedback On State Of The IBM i Base, IBM i Salaries

  April 11, 2022 Timothy Prickett Morgan

  Hey, TPM:

  I have been enjoying your series on the state of the IBM i environment. Those and other recent IT Jungle articles have helped me better understand some of the things that I am seeing as a training vendor.

  As you and I have often discussed, the IBM i market has divided into two groups: the roughly 30,000 active customers and 120,000 others. My company, Manta Technologies, has customers among both groups.

  As a former math professor, I tend to think in Venn diagrams. I had to fight the urge to pull out the colored pencils when I read …

  Read more

• 7.1 Flew Over The Cuckoo’s Nest

  April 4, 2022 Timothy Prickett Morgan

  We think there is a lot of Power7, Power7+, and Power8 iron out there in the Power Systems running IBM i base, and we think there is a lot of IBM i 6.1 and IBM i 7.1 running on that iron. Our assertion is based on years of anecdotal evidence from the resellers and business partners we talk to, the customers we talk to, and a whole lot of spreadsheet witchcraft that we do based on survey data we see.

  The point is not just to come up with this data and then drop it and run, but to face …

  Read more

• IBM Wheels And Deals With Solution Edition Booster Pack

  June 8, 2020 Timothy Prickett Morgan

  A few weeks ago, we told you about the double memory and double I/O request for price quote (RPQ) special deals that IBM quietly rolled out in April without putting out any announcement letters and that are still in effect until June 30. So consider this a reminder that these deals are still out there and now is a good time to invest in new Power9 iron if you want to pay less for it than you otherwise might.

  But that is not all you can get. As it turns out, Big Blue is revamping its IBM i Solution Edition …

  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: 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

• 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

Previous Articles Next Articles