IBM i & SQL Tips: Finding Unused Objects with QSYS2.OBJECT_STATISTICS
11 September 2025
I’d like to share with you this interesting post by Massimo Duca, the first in a series of articles dedicated to SQL on IBM i. In this contribution, Massimo shows how to leverage the QSYS2.OBJECT_STATISTICS…
---
Roberto De Pedrini
Faq400.com
Remove old spool files to keep track of the number of jobs in the system (SQL procedure version)
11 September 2025
In my last article “Remove old spooled files to keep track of the number of jobs in the system” I published the source of a CLLE program that removes spooled files selected by JOBNAME, USERNAME,…
Remove old spooled files to keep track of the number of jobs in the system
7 August 2025
The system value QMAXJOB (valid range: 32,000 – 970,000; default = 163,520) defines the maximum number of jobs that can exist on an IBM i system. This value takes into account active jobs, queued jobs,…
IBM i: System Management is Simpler Than You Think
25 February 2025
If you work with IBM i, I recommend reading this insightful article by Giancarlo Lui: IBM i System Management: Simpler Than You Think. The author explores tools and approaches to streamline system management, making it…
---
Roberto De Pedrini
Faq400.com
RPG Free and option(*convert) for paramters
24 February 2025
In his recent article “RPG Free and option *convert” , Aldo Succi explores the *CONVERT option in the RPG language, highlighting how this directive allows the compiler to automatically convert parameters passed to a procedure…
---
Roberto De Pedrini
Faq400.com
CA Certificate Update for the European Central Bank (ECB): A Practical Guide
22 February 2025
Updating Java and DCM Certificates for ECB Exchange Rate Retrieval on IBM i In our blog, we have previously discussed how to download exchange rates from the European Central Bank (ECB) using a simple SQL…
---
Roberto De Pedrini
Faq400.com
Managing Locked Display Files on IBM i: An Effective Solution
7 November 2024
We are pleased to receive and share this “tip & trick” from Patrick Rizzi, which introduces a technique that allows for intervention (modification and compilation) on any display files (DSPF) in use. We all know…
---
Roberto De Pedrini
Faq400.com
