Blog

​[[{“value”:”In the previous article, I showed how to create an RPG stored procedure that uses parameters. In this article, I’m going to show how to create an RPG stored procedure that returns a result set, as we would likely encounter this scenario more frequently. The data used in this example comes from the Department table from IBM’s Sample database.
I created an RPG program (Figure 1) that selects all rows from the Departments table. I didn’t add any selection criteria as I know there aren’t many rows in the table, but you may want to limit the number of rows …
The post Guru: Creating An RPG Stored Procedure That Returns A Result Set appeared first on IT Jungle.”}]] Read More 

​[[{“value”:”Automating the monitoring of IBM i messages was just the start for Shield Advanced Solutions and its AAG offering. This month, the company announced that the Nagios-based tool has been bolstered with support for Ansible, which gives it the capability to automatically respond and take actions based on certain IBM i messages.
Shield Advanced Solutions launched AAG, which stands for At-A-Glance, back in 2023 as a way to help its customers monitor high availably setups. Shield President Chris Hird was aghast that some IBM i shops were leaving mirrored pairs under monitored, which reduced the odds the systems would be …
The post Shield Adds Task Automation To Message Monitoring Tool appeared first on IT Jungle.”}]] Read More 

​[[{“value”:”Last week was a busy week for PTF patches, but not for security vulnerabilities. And this week is even quieter, but there are new defective PTF reports this week that you need to keep an eye on, as is usually the case in most weeks.
Here is the rundown of PTF Groups by IBM i release level since we last published:
PTF Groups 7.5:

None

PTF Groups 7.4:

MQ for IBM i – v9.0.0/v9.1.0/v9.2.0/v9.3.0

PTF Groups 7.3:

None

Tip O’ The Week: We are thinking.
New (or Updated) links added to the ‘Links’ tab in The Guide this week:

None

…
The post IBM i PTF Guide, Volume 27, Number 11 appeared first on IT Jungle.”}]] Read More 

​05 IBM Power Rockstars, this one’s a must-listen! On this episode of The Incredible i Show, we sit down with Ted Macksam, an IT leader who’s pushing the boundaries of modernization on IBM i.Imagine running your entire IBM i ERP without traditional green screens, without terminal sessions, and without legacy roadblocks—just open-source technology and browser-based access. That’s the reality at Hatco, and Ted is here to share exactly how they did it.We’ll explore: Their journey from legacy ERP to 100% open-source, web-driven IBM iHow their team executes seamless DR switchovers in under 30 minutesThe transformation of an RPG programmer into a full-stack open-source developerThe importance of succession planning and what the future holds for IBM i IT teamsTed Macksam, VP of Information Technology at HatcoEmail: [email protected]  LinkedInOne incredible Th(i)ng!  Products, gadgets, recipes, music or things we are loving right now.Ted’s pick for this week:Family vacation in Dominican Republic Peg’s pick for this week:College kid coming home for spring break!Upcoming EVENTS:NEUGC, April 7-9, 2025 POWERUp 2025, Anaheim, CA – May 19-22, 2025SHOW SPONSORS:LightedgeCOMMONCheck out our website and LinkedIn page, and like and subscribe to all those things!Interested in sharing your IBM i story? Want to sponsor the podcast? We want to hear from you! Reach out to Peg.Email: [email protected] Read More 

​[[{“value”:”While installing ACS thei first time, I forgot to install “Run SQL Scripts” feature, how can I remedy to this?
Reinstall the whole thing again? Thanks for letting me know.
submitted by /u/jedimaster1974[link][comments]”}]] Read More