• How To Have The Wisdom Of Experts Woven Into Your Code

  October 14, 2024 Nicholas DeLessio

  No matter how far you are down the road with your DevOps automation journey, or even if you’re not yet starting that journey, it’s probably a good idea to have a code checker; not everyone can have a Linus Torvalds review their work (as famously happens with the open source Linux kernel), but there are automation tools available for various languages and platforms that do static code analysis and they are the next best thing.

  These tools, sometimes called “code linters” (because they remove the fuzzy bits out of application logic like actual linters remove imperfections stuck to our clothing), …

  Read more

• Untangling Legacy Spaghetti Code To Cook Up Microservices

  August 12, 2024 Michel Mouchon

  At this point in the history of programming, everyone pretty much knows what microservices are and everybody is more than acquainted with the legacy code – and often monolithic code – that has been created over decades by countless programmers who have evolved corporate applications to fit new conditions and new demands.

  It is often called spaghetti code, and for good reason. The code is often a tangled mess of business logic and data – presumably the data is the meatballs and the user interface is the sauce in this metaphor. (It is important to not take a metaphor too …

  Read more

• Guru: The Transition From Modern RPG IV To Modern SQL

  October 30, 2023 Bob Cozzi

  Seven or eight years ago I was working with a client who needed more contemporary reporting than provided by the legacy Query/400 product. Initially I looked at Db2 Web Query and realized the documentation was sparse and the tutorials for most things, even “getting started” were virtually non-existent. It was also about four times more expensive than I felt it was worth to a P05 or P10 client. I mentioned the documentation issue to the folks at IBM and they agreed. Some of it was eventually resolved, but not enough in my opinion to get the masses to replace Query/400 …

  Read more

• 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

Previous Articles