• Guru: Partitioning Result Sets Using SQL

  November 27, 2023 Mike Larsen

  While working on a project recently, I needed to retrieve attributes of an item. While that sounds like a simple task, there was a twist. While reviewing the contents of the item master table, I noticed there could be multiple rows for the same item and each row was active and valid from a business perspective.

  I won’t get into the business end of it, but my goal was to return the most recent iteration of the item for further processing in the program. After doing some research and trying some potential solutions, I came across the SQL partition by …

  Read more

• As I See It: Elusive Connections

  November 27, 2023 Victor Rozek

  Between the ages of 2 and 6, I formed a deep attachment to a small stuffed bear. I played with it, talked to it, and slept with it. It was my constant companion and before I moved on in my development, I had loved much of its fur off.

  America, according to mental health experts, is experiencing a loneliness epidemic. On a planet straining with the weight of 8 billion people, it seems that an uncanny number lack meaningful connection. A problem not likely to be solved by embracing stuffed animals.

  In a study commissioned by healthcare/insurance giant Cigna, “more …

  Read more

• IBM i PTF Guide, Volume 25, Number 47

  November 27, 2023 Doug Bidwell

  Happy Belated Thanksgiving, welcome back to work, and pass the turkey and cranberry sauce leftovers if you don’t mind.

  Speaking of leftovers, there are some new patches for IBM i 7.2, which were updated on November 14. You can check out SF99719 720 Group HIPER – level 237 at this link and SF99718 720 Group Security – level 126 at that link.

  There is also a security vulnerability you need to be aware of, specifically Security Bulletin: Multiple Vulnerabilities in IBM Java SDK affect IBM WebSphere Application Server and IBM WebSphere Application Server Liberty due to the October 2023 …

  Read more

• AWS Inks Deal With Connectria To Have a Power Play

  November 15, 2023 Timothy Prickett Morgan

  The long road of history has not been made impassible by the charred marketing tanks and flaming sales assault vehicles of those who have tried to breach Fortress Rochester, but there are a whole lot of rusting machines off on the horizon cluttering the road and more than a few smoking machines nearby as well as some sizable holes in the ramparts out on that cornfield in Minnesota.

  While the proprietary minicomputer businesses and the Unix server businesses of the competition of the AS/400 and IBM i platform have all been destroyed and that IBM is indeed the last bastion …

  Read more

• IBM i Shops Have Alternatives to Db2 Web Query

  November 15, 2023 Alex Woodie

  The sudden demise of Db2 Web Query has sent customers looking for alternatives. The good news is that IBM i software vendors offer a number of pre-built solutions that can fit the bill.

  Here are some potential business intelligence tools from vendors that could serve as replacements to Db2 Web Query. We’ll take a look at open source alternatives in a future article.

  Cozzi Research SQL World

  Cozzi Research develops two query tools for IBM i, including SQL iQuery and SQL Tools, and bundles them both in a single product called SQL World.

  Cozzi positions SQL iQuery as a native …

  Read more

• Eradani Lays Waste to API Payload Restrictions

  November 15, 2023 Alex Woodie

  Eradani Connect customers who need to pass large amounts of data to IBM i via external API calls have often been stymied by a built-in restriction in IBM i that limits their payload to a mere 16MB. Those customers will be thrilled that Eradani has launched a new big data connector that smashes those payload restrictions to smithereens.

  Eradani Connect is a packaged application designed to simplify the creation and execution of API calls on IBM i. The software functions as a middleware layer that makes it easy for .NET, JavaScript, and Python developers to get access to the IBM …

  Read more

• Four Hundred Monitor, November 15

  November 15, 2023 Jenny Thomas

  If you’re looking for the next generation of IBM i, let us introduce you to the COMMON Education Foundation. CEF is dedicated to educating and engaging future IT generations. This week, CEF is hosting a virtual meet and greet to bring students together with working IBM i professionals and organizations who are seeking talent. CEF is a nonprofit supported by community contributions and volunteers who want to see the IBM i ecosystem continue to survive and thrive. Find out more about the meet and greet on November 16 in our Redbooks, White Papers, Blogs, Podcasts, and Other Resources section below. …

  Read more

• Old PHP and Other PASE Apps Break on IBM i 7.5

  November 15, 2023 Alex Woodie

  Customers running old versions of PHP and other PASE applications like Node.JS may run into compatibility issues when running on IBM i 7.5. The issue is due to an upgrade in OpenSSL support in the latest release of the IBM i operating system, according to Alan Seiden.

  Seiden, the principle of Seiden Group, first sounded the alarm in July about the problems running older, non-RPM versions of PHP and Node.JS on IBM i 7.5, which was upgraded from OpenSSL version 1.0.2 to version 1.1. In October, he recently published a blog post restating the issue.

  “While [the OpenSSL upgrade …

  Read more

• New GM Wants To Push IBM Power With Hybrid Cloud And AI

  November 13, 2023 Timothy Prickett Morgan

  Three months ago, the Power division within IBM’s Infrastructure group got a new general manager. This changing of the guard happens every couple of years as Big Blue moves executives around so they can get managerial experience across different lines of business, and this time around, it is Tom McPherson who has been tapped for the top job in the division that is the home of the IBM i platform.

  McPherson got his bachelor’s degree in electrical and electronics engineering from Rutgers University in 1990 and got his master’s degree in computer engineering from Syracuse University in 1994. We don’t …

  Read more

• IBM Finally Comments On Db2 Web Query For i Withdrawal

  November 13, 2023 Timothy Prickett Morgan

  A little more than a month ago, in announcement letter AD23-0691, IBM abruptly announced the end of marketing for all variations of the Db2 Web Query for i data analytics tool.

  At the time, neither IBM nor its partner, TIBCO Software – which is part of Cloud Software Group, a conglomerate that owns TIBCO (which bought Information Builders and Spotfire), JasperSoft, and Citrix Systems (which includes products from Citrix, NetScaler, ShareFile, and XenServer) – had anything to say about the partnership between IBM and TIBCO/Information Builders coming undone.

  But something has happened between Big Blue on the one hand …

  Read more

Previous Articles Next Articles