• Guru: Generating XML Using SQL – The Easy Way

  September 18, 2023 Bob Cozzi

  There are many verbose methods of generating XML. You can:

  • Write your own RPG code
  • Using a free or third-party API
  • Use SQL iQuery OUTPUT(*XML) option
  • Use the built-in SQL XML functions such as XMLELEMENT

  I’m sure there are others, but these seem to be the most popular.

  For years I had been using the XMLELEMENT approach; a rather verbose set of XML function built into Db2 for i SQL. In fact, SQL iQuery’s OUTPUT(*XML) is based on that feature. It simply regenerates your SQL statement using XMLELEMENT statements for each output column/field name.

  But if you’re using something IBM …

  Read more

• How Long Before Big Blue Brings Code Assist To IBM i?

  August 23, 2023 Timothy Prickett Morgan

  IBM Research and Big Blue’s Software group have been collaborating to bring generative AI capabilities to market through the Watsonx stack of large language models and related tools. Watsonx is a basis for customers to create customized LLMs based on data from their own businesses and to integrate the quasi-cognitive capabilities of LLMs into their applications.

  Watsonx is also being used by IBM to augment some tools of its own, and the most recent one that will be in tech preview in September and generally available sometime in the fourth quarter is called Watsonx Code Assistant for Z, which as …

  Read more

• 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

Previous Articles