[[{“value”:”Welcome to your IBM i update for April 2025 – a snapshot of news and views on what’s been happening in the IBM i community in the past few weeks as reported by Proximity. This month we discuss the announcement on v7.6 of IBM i as provided by Steve Will on the 10th April. Elon
The post IBM i Update: April 2025 appeared first on Proximity.”}]] Read More
LISTAGG scalar function can return distinct results [email protected] (Simon Hutchinson)
[[{“value”:”I did not realize it had been so long since I first wrote about the LISTAGG scalar function. I mentioned very briefly in that article something that became very useful to me just a short while ago.
The LISTAGG scalar function aggregates the results from a one or more rows into a single new column, separated by a character of my choice.
In my scenario I have a table, TESTTABLE, that contains a column of colors, COLOR:
01 SELECT COLOR,COUNT(*) “Count”
02 FROM TESTTABLE
03 GROUP BY COLOR
Read more »”}]] Read More
A review of the Fortra IBM i Marketplace Survey PaulR
[[{“value”:”In January 2025, Fortra released the results from their latest IBM i Marketplace survey. This year’s survey is the 11th that Fortra has released. Each one offers a comprehensive and valuable insight into the state of the IBM i ecosystem year-by-year. Andy Nicholson has covered previous releases in his IBM i Update (which you can
The post A review of the Fortra IBM i Marketplace Survey appeared first on Proximity.”}]] Read More
IBM i Next: Insights from Steve Will, Chief Technology Officer Michel Roethlisberger
Inscription: IBM i Next: Insights from Steve Will, Chief Technology Officer – Register here Thu, Apr 10, 2025 15:00 CET Online Description A lot is happening on the IBM i platform. Join Steve Will, IBM i Chief Technology Officer and Distinguished Engineer, to hear key insights into the evolution of the platform and what is […] Read More
Client Access – The Connection Tool for AS400, iSERIES and IBM i Systems Nick Litten
Welcome to this lesson on How to Install Legacy IBM Client Access for Users! Buckle up, because we’re taking a wild ride back to the days of floppy disks and dial-up vibes with the OG IBM Client Access—the pre-ACS hero of AS/400, iSeries, and IBM i connectivity. Perfect for those brave souls still rocking a Windows XP vibe or just wanting to flex some retro IT skills, this session will walk you through digging up those ancient install files and slapping them onto your system like it’s 1999. Get ready to laugh at the quirks and conquer the setup—let’s resurrect this dinosaur with a grin!https://www.nicklitten.com/module/ibm-client-access/ Read More
