Month: November 2023

​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 …
The post Guru: Partitioning Result Sets Using SQL appeared first on IT Jungle. Read More 

​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 …
The post IBM i PTF Guide, Volume 25, Number 47 appeared first on IT Jungle. Read More 

​In this example video, I’d like to show you how the new feature SELECT with operand and WHEN-IS/WHEN-IN can be used in RPG.
0:50 Creating a new source for my RPG program Read More 

​IBM Power and the Importance of Measurable Results  TechSpective Read More 

​I am often asked this: How do I capture a list of all the jobs running and the CPU these are using every few minutes. [ #IBMi #rpgpgm #IBMChampion ]
https://www.rpgpgm.com/2023/11/program-to-capture-cpu-usage-over-time.html
submitted by /u/RPGPGM[link][comments] Read More