• Guru: Scalar Use of LISTAGG

  August 24, 2020 Ted Holt

  The SQL LISTAGG function is as handy as a pocket. Only recently I used it to build a string of comma-separated values (CSV) to populate a drop-down box. It sure beats a cursor and a loop. I’ve noticed in my reading that LISTAGG can be used for both aggregate and scalar purposes under Oracle. Db2 doesn’t support the scalar use, but I found another way to do the same thing.

  To see what I’m talking about, check out example 7 in the article Oracle LISTAGG Function Usage, Tips & Examples, by Ben Brumm. I recommend studying the entire article; …

  Read more

• New Option Emerges for Refactoring IBM i Apps

  August 19, 2020 Alex Woodie

  IBM i shops that want to refactor their RPG and COBOL applications into different languages have a new option available to them. In late June, Astadia and Blu Age announced they’re working together on a new service that automates the conversion of customers’ older apps into Java and .NET code that can run on X86 systems in your basement or the cloud.

  Based in Boston, Massachusetts, Astadia claims to have completed more than 200 mainframe migrations and more than 100 mainframe modernization projects over about two-and-a-half decades. The company has modernized millions of lines of COBOL code running on mainframes …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

• ARCAD Generates APIs From 5250 Screens

  July 22, 2020 Alex Woodie

  Many IBM i shops want to modernize their 5250 applications by developing REST-based Web services and API extensions, but they face difficulties getting started. These organizations may want to check out ARCAD Software’s latest offering, ARCAD API, which takes much of the pain and complexity out of the API generation process.

  REST-based APIs have become a standard method for exposing data and business logic to the outside world. There’s an abundance of ways that APIs can be used–pushing data to Web or mobile users, for example, or pulling data from a cloud-based CRM system. Just about any higher-level application function, …

  Read more

• More Open Source Databases Coming To IBM i

  June 15, 2020 Alex Woodie

  IBM is in the process of bringing several new open source databases to the IBM i platform, including schema-less NoSQL databases as well traditional relational systems. Among the databases that Rochester is targeting are MongoDB, arguably the most popular NoSQL database and a favorite among Web and mobile developers, as well as PostgreSQL, one of the industry’s oldest and most widely used relational databases.

  Databases today almost are like programming languages, with developers mixing and matching databases to handle different functions, often within the same application. DB-Engines.com tracks more than 330 distinct databases, while there are somewhere around 700 programming …

  Read more

• Thoroughly Modern: Quick Digital Transformation Wins With Web And Mobile IBM i Apps

  May 27, 2020 Kevin Cronin

  The future of IT no longer involves hiding in the basement and pushing buttons. In today’s digital economy, the role of IT – and IBM i – is critical. Internal users and customers are demanding modern, intuitive applications that are easy to access. If you’re an IT leader, you’re likely meeting with business stakeholders, discussing how you can grow and improve your business, and looking at what’s available to satisfy those needs.

  As my colleagues have discussed in previous installments of this column, failing to innovate in your market could put your business at risk. Digital disruption is happening …

  Read more

• What’s New With Db2 Web Query?

  May 11, 2020 Alex Woodie

  Db2 Web Query, which is IBM’s strategic business intelligence tool for IBM i, doesn’t follow the same release cycle as the operating system itself. But as part of activity surrounding the latest round of Technology Refreshes (TR) for IBM i 7.3 and 7.4, IBM discussed the recent updates that it’s made to Db2 Web Query, along with new features that are due very soon.

  To get the lowdown on the new Db2 Web Query features, we tuned into a recent presentation made by Doug Mack, IBM’s Db2 Web Query product manager. Mack presented a session with Db2 for i …

  Read more

• Big Blue Makes Moves To Mainstream Db2 Mirror

  May 4, 2020 Timothy Prickett Morgan

  When IBM brought out its active-active Db2 for i database clustering extensions, called Db2 Mirror appropriately enough, almost exactly a year ago to improve the resiliency of databases and therefore the applications that run atop them on the IBM i platform, we had a few asks. As part of the April Technology Refresh announcements for IBM i 7.3 and 7.4, some of those asks are answered and it looks like another one might be in the works.

  The two most important things that we asked for are related, and it is all about making Db2 Mirror available and affordable for …

  Read more

• New IBM Champions Reflect on Their Journeys

  February 26, 2020 Alex Woodie

  IBM has rolled out its new list of Champions for Power, and on the list are eight men from the IBM i community who have been named Champions for the first time. Among the honorees is the Four Hundred Guru himself, Ted Holt.

  Ted Holt: IT Jungle guru and senior software developer at Profound Logic

  

  Holt’s day job is working as a senior software developer for Profound Logic. But at night he becomes the IT Jungle’s Guru, dispensing IBM i code and snippets of hard-won wisdom as a senior technical editor of The Four Hundred. He also tweets from …

  Read more

• A Lifeline For CIOs, The Toughest Job In IT

  February 24, 2020 Alex Woodie

  Let’s hear it for chief information officers, who have the toughest jobs in IT. If you’re good enough and lucky enough to succeed with your initiatives, you get to keep your job another year. But if the plans fall through, then you’re out on the curb. It’s a lonely job, but thanks to the CIO Summit event that Alan Seiden puts on with System i Developer, the CIOs at IBM i shops at least have a lifeline for support.

  Research shows that CIOs have among the shortest tenures of any position in the C-suite. The management consulting firm Korn Ferry …

  Read more

Previous Articles