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
SQL: SELECT with "superpowers"
24 November 2023
With a little trick even a simple SELECT statement can execute any system command! Let’s see how to do that…
Create SQL Views to interpret QSYS2.DISPLAY_JOURNAL
10 March 2023
The sources (SQL statement) of this post are available on Github at this link: https://github.com/Faq400Git/Create_Display_Journal_Table_View Personally I am a big fan of IBM i Services, that series of SQL Functions (UDF and UDTF) and Stored…
---
Roberto De Pedrini
Faq400.com
How to use REST API on IBM i: the Open Banking example
19 February 2023
The IBM i system, being a robust and versatile business server, can easily connect to the world of REST APIs, enriching the applications it hosts with features taken from the cloud.In today’s example we will…
Multi-member file and SQL
5 January 2023
I recommend this post by Aldo Succi from his blog “IBM i (AS/400) Fans Only” on the topic of Multimember Physical Files and SQL. The concept of multi-member file is a purely DB2 AS/400 thing…
---
Roberto De Pedrini
Faq400.com
Drawing with DB2 for i SQL - Happy New Year 2022!
31 December 2021
Of course one must have time to waste to spend the whole afternoon trying to draw, with recursive SQL queries, Christmas trees, other amenities, the last day of the year (Today 31 December 2021) Actually,…
---
Roberto De Pedrini
Faq400.com
DB2 for i SQL JSON_OBJECT Essential Cheat Sheet
3 October 2021
Whenever I have to create a JSON document for a Post-REST Web Service, I have to open previous programs and do a great job of copying and pasting … I thought that creating a small…
---
Roberto De Pedrini
Faq400.com
